Linking DTS Packages

[DebbieChapman]

Is it possible to link 2 DTS Packages togeather. I have created 2 packages, but I only want package 2 to run if package 1 is successful

 

[JohnDTampaBay]

What version of SQL are you running? In SQL 2000, there is a Run Package task. You can create a third package that runs the first and, if successful, runs the second.

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.

 

[DebbieChapman]

I'm using SQL Version 7

 

[JohnDTampaBay]

I can't remember if SQL 7 has a Run Package task. If not, you could add an Execute SQL task as the last task of package 1. Use this task to call DTSRun to run package 2. Use workflow control to run the task only if the prior task is successful.

Good luck!

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.

 

[MaffewW]

I dont think SQL7 has that option. What you can do though as a workaround, is on successfulk completion on package1, on success run an execute sql task and use xp_cmdshell to call dtsrun, the command line option for executing dts pacages


Matt

Brighton, UK