|
Home > Archive > MS SQL Server DTS > June 2005 > Run Multiple dts packages from a job.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Run Multiple dts packages from a job.
|
|
|
| I would like to create a job from enterprise manager with 3 steps, each step
execute a DTS package by order.
Can I do that? Any help will be appreciated.
| |
|
| Approch 1:
Create a DTS package and add 3 Execute Package Tasks to call the dts
packages in the order and schedule the new package
Approch 2:
use dtsrunui command line utility. Select the DTS package. Go to "Advanced"
and generate the encrypted command for the package.
Repeat for all 3 packages. Scheduled the encrypted commands in 3 steps.
--
Thanks
Ravi
"Sally" wrote:
> I would like to create a job from enterprise manager with 3 steps, each step
> execute a DTS package by order.
>
> Can I do that? Any help will be appreciated.
| |
| Allan Mitchell 2005-06-28, 1:23 pm |
| Sure
Simply go to the jobs section in Enterprise Manager
Add Step 1 - Insert the correct DTSRUN statement (CmdExec)
repeat for step 2 & 3
You can then link the steps with the On Success or On Failure parts of the
step
hint: If you want an easy way to generate the DTSRUN cmd then use
Start | Run | DTSRUNUI
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know
"Sally" <Sally@discussions.microsoft.com> wrote in message
news:9434FA48-EC90-4985-A9D2- 7A9D75F57580@microso
ft.com...
>I would like to create a job from enterprise manager with 3 steps, each
>step
> execute a DTS package by order.
>
> Can I do that? Any help will be appreciated.
|
|
|
|
|