I have a step in a DTS package that needs to run for ~5 mins before going on
to the next step. What task can be inserted between step1 and step2 to
accomplish this?

You can insert a Execute SQL Task within the two steps and the execute the
following SQL:

WAITFOR DELAY '00;00:15'

to wait for 15 seconds.

"SQLCat" wrote:

Hello Shannon,

That will only cause that one step to wait for 15 seconds not make the originally
executing step execute for 15 seconds before moving on.


AFAIK you cannot insert a step between A nd B to make A only run for 5 minutes
before moving on.


What is it that you want to execute for 5 mins then move on?


To do this nicely I think you will have to manage the timings within the
original step





Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com