Run DTS packages from One DTS Package

#1

Is it possible to run multiple DTS packages from ONE DTS Package? Thanks!

#2

Hello Shawn,

Yep.

Number of ways

1. ExecutePackage task
2. Script task through object model
3. sp_start_job to start a job that runs a package (ExecuteSQL task)
4. sp_OA* (ExecuteSQL task)

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Quote:

Is it possible to run multiple DTS packages from ONE DTS Package?
Thanks!

#3

Thanks Allan,

I used the Execute Package task and it appears to work fine. Thanks, I didn't even notice the tool in the toolbox.

Shawn

Quote:

Allan Mitchell<allan (AT) no-spam (DOT) sqldts.com> 03/04/06 11:15 AM

Hello Shawn,

Yep.

Number of ways

1. ExecutePackage task
2. Script task through object model
3. sp_start_job to start a job that runs a package (ExecuteSQL task)
4. sp_OA* (ExecuteSQL task)

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Quote:

Is it possible to run multiple DTS packages from ONE DTS Package?
Thanks!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Run DTS packages from One DTS Package

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Run DTS packages from One DTS Package - 03-04-2006 , 09:37 AM

Re: Run DTS packages from One DTS Package - 03-04-2006 , 10:15 AM

Re: Run DTS packages from One DTS Package - 03-06-2006 , 03:05 PM