Itay.B
Itay.B

Reputation: 4111

SSIS Exec two packages from one parent

I have a parent package that needs to exec two child packages with a small delay between them. The problem is that the 2nd package won't execute after the 10 seconds delay. Any idea?

Thanks.

SSIS

Upvotes: 0

Views: 116

Answers (1)

Josh Jay
Josh Jay

Reputation: 1250

Using SQL WAITFOR DELAY '00:00:10' in an execute SQL task worked for me.

http://www.sqlchick.com/entries/2011/5/1/creating-a-time-delay-in-ssis-when-loading-master-data-servi.html

Upvotes: 1

Related Questions