Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SSIS:Transfer SQL Object Task:Delay between Start of Task & Execution

Status
Not open for further replies.

rackman99

Programmer
Sep 16, 2002
29
GB
Hi,
I use a TSOT to copy approx 700 tables between one server and another as an overnight package. This data is set to replace and there are no other objects (views, etc) being copied. What I have noticed by looking at the event log, is that it takes about 1 and 1/2 hours between the package being started and the data to start copying over. In the progress tab it tells me that all the Tables alread exist in the destination (as expected), that there are no other objects to copy. Then it just sits there till the event log starts to record the table copies. I have tried changing it to a replace (thus removing the drop and recreate) and doing a Truncation on all the tables beforehand, but this has not made any differece. Any ideas on what causes this delay and how to remove it would be appreciated.
 
Hi, Not sure why you are seeing such a long delay with the Transfer SQL Objects task, I haven't used much myself as I found it too fiddly to configure - this blog post below describes a way of creating your own object transfer using a Script Task that uses SQL Management Objects, which is basically what the TSOT does in the background.


The documentation for the SMO Transfer class is here:

Hope that helps!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top