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:

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 (AT) discussions (DOT) microsoft.com> wrote