I have a ssis package that does two operations. 1) it downloads data from oracle to sql and then load data from sql to another sql database. In both the operation it uses 2 stored procedure to update the table after comparing the data.
When I run the package it takes around 2 hours to run
when I run the Sproc it takes 22 minutes
When I run just the package to download data it takes less than a minute
How can I troubleshoot.
asked Aug 11, 2017 at 01:35 PM in Default