Execute package from within a package?

#1

I have a DTS package (DTS#1) that has an ActiveX script that compares two
values to determine whether package DTS#2 should be executed or not. Does
anyone have an example of how to execute a package from within an ActiveX
script or is there a better way to handle this?

TIA. Chris.

#2

You can either use the ExecutePackage task or you can call the object model
in you ActiveX script as you mention. Have a look here

Execute a package from a package
(http://www.sqldts.com/default.aspx?215)

--

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

"Chris W" <ChrisW (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have a DTS package (DTS#1) that has an ActiveX script that compares two
values to determine whether package DTS#2 should be executed or not. Does
anyone have an example of how to execute a package from within an ActiveX
script or is there a better way to handle this?

TIA. Chris.

#3

The ActiveX script worked like a charm...thanks!

"Allan Mitchell" wrote:

Quote:

You can either use the ExecutePackage task or you can call the object model
in you ActiveX script as you mention. Have a look here

Execute a package from a package
(http://www.sqldts.com/default.aspx?215)

--

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

"Chris W" <ChrisW (AT) discussions (DOT) microsoft.com> wrote in message
news:C8931D6E-61B8-41EC-A6AF-EF3E89E21E60 (AT) microsoft (DOT) com...
I have a DTS package (DTS#1) that has an ActiveX script that compares two
values to determine whether package DTS#2 should be executed or not. Does
anyone have an example of how to execute a package from within an ActiveX
script or is there a better way to handle this?

TIA. Chris.

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

Execute package from within a package?

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

Execute package from within a package? - 06-13-2005 , 04:16 PM

Re: Execute package from within a package? - 06-13-2005 , 04:54 PM

Re: Execute package from within a package? - 06-14-2005 , 08:25 AM