Discussion in 'SQL Server DTS-Related Questions' started by sonijaiswal, Oct 30, 2007.
1.How can we run multiple DTS packages in a single job.Please throw some ideas.
Can anyone other than Satya answer, or just him?
sorry , its open for everyone
Just add as much job steps as you need and execute the package from the command line via xp_cmdshell and dtsrun. You might want to specify for each step how to proceed on success and error.
 LOL Tom....
Refer to your own question before posting such duplicate posts, I have answered to similar post earlier.
Instead of Job, you can even create a Parent package and can call many child packages in it based on event failure, success or complete.
Separate names with a comma.