Santhosh Kumar
Right there with Babe
Points: 766
More actions
October 24, 2005 at 10:17 am
#60294
Hi,
I have a series of steps in a steps in a DTS package, I want to know how to add a delay of say 5 secs between steps. Thanks in advance.
with smiles
santhosh
Don Staten
SSC Eights!
Points: 957
October 24, 2005 at 10:48 am
#599592
Use the TSQL command "WAITFOR". For a 5 second delay, place this line in an Execute SQL Task:
WAITFOR DELAY '00:00:05'
SQL Server Books Online discusses this command in more depth.
Have a good one
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply