Add delay in DTS Package

• 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

  More actions

  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