SSIS Package Running Time

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.

more ▼

asked Aug 11, 2017 at 01:35 PM in Default

avatar image


(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Aug 11, 2017 at 01:35 PM

Seen: 12 times

Last Updated: Aug 11, 2017 at 01:35 PM

Copyright 2018 Redgate Software. Privacy Policy