Home > Archive > MS SQL Server DTS > March 2006 > DTS "Execute SQL Task"









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author DTS "Execute SQL Task"
nick

2006-03-26, 8:27 pm

I have a Execute SQL Task that copy/transfer a big SQL table by executing:

insert into .... select ... from ....

Is there any benefit to run the sql in DTS (batch/lock handling)? Or it's
the same to run it use Job schedule or just isqlw?
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com