November 4, 2002 at 2:13 pm
Hi,
I am new to DTS, I have created couple of Packages for one Database and SQL Server is 2000.
I want to Exec one Package after the other. Its just like clicking a Single button and Dump all the data by Executing one package after the other.
How do I go for it, Some 1 plez..help..
Thanks
November 4, 2002 at 2:24 pm
There are a few ways to go about doing it...but perhaps the easiest way to start is to create another package...in this package place two Execute Package task objects...have these execute package tasks run your existing packages...you can connect them with an on complete or on success workflow and then you only have to run your main or 'master' package and your two existing packages will execute one after the other...
hth,
Michael
Michael Weiss
Michael Weiss
November 4, 2002 at 4:17 pm
Two other ways I have done in the past.
1) Right click a DTS package and do schedule, then the job it creates get the details of the step and put into a job of your own in logical order (delete the one you used to get this info). The you can keep job as not enabled and use sp_start_job to kick it off.
2) Same thing but copy the command string from the job it creates into an SP and use xp_cmdshell to execute them one by one. Now you have an SP you can use.
November 5, 2002 at 12:20 pm
Apart from the option which Anteras686 you can also use dtsrun utility.
Example. dtsrun /Sserver_name /Uuser_nName /Ppassword /Npackage_name /Mpackage-password
Hope this will help.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply