Thursday, March 29, 2012

DTS schedule

I have 2 DTS and i want to make sure that DTS2 runs after the DTS1 has finished, how can i do this??
Thanks,
Joo MartinsCan you run dts2 within dts1 or does it have to be run outside of dts1 ?|||dts2 must run outside dts1|||When you schedule a DTS package using EM, it creates a job with the name same as the package. This job has only one step - with the name same as the package. However, you can add more steps to the job and specify the sequence in which they will run. The job will be under EM - Server - Management - SQL Server agent - Jobs.sqlsql

No comments:

Post a Comment