Saturday, February 25, 2012

Schedule DTS Packages to run sequentially

Hi,

I have eight DTS packages. I would like to schedule all of time to run every night. Can I do this in sequence like something similar to scheduling "Job" in SQL Server Agent, when package one finish, immediately execute package two, then package three...and so on.

Any ideas? Thanks in advance.

SnoopyCreate a job, each step in the job can be the next package.

Step1 = Package1
Step2 = Package2
ect.....|||SHICKS:
Thanks. Can you tell me how to do it? Can I do it through SQL Server Agent?
When I go to SQL Agent -> New Job -> steps -> New Job steps, I don't know where to specify my package. Or should I do in by other methods? Thanks in advance.|||If you are using SQL 2000 Client you can define a dts Package Run object at the end of each DTS Package.

SQL 7 CLient does not have this functionality

No comments:

Post a Comment