Anyone????????

[Mattus]

How do I execute an existing package within a package within an ActiveX Script
task??

I want to call out to another package on my sql server during execution of
a loop within an ActiveX Script Task. Experimenting with the object model
of DTS has seems that it will allow me to create a package through code,
but all I want to do is execute a package that was already created with the
DTS designer in SQL Server. Can't a just says something like oPackage.Execute
("packagname") ??

Can anyone help????

[Some Dude]

In your package there is an "Excute Package Task" task. This will let you
run another package from within the current one.

I hope that will help a little.

Some Dude

"Mattus" <LiquidCorn@hotmail.com> wrote:
>
>How do I execute an existing package within a package within an ActiveX
Script
>task??
>
>I want to call out to another package on my sql server during execution
of
>a loop within an ActiveX Script Task. Experimenting with the object model
>of DTS has seems that it will allow me to create a package through code,
>but all I want to do is execute a package that was already created with
the
>DTS designer in SQL Server. Can't a just says something like oPackage.Execute
>("packagname") ??
>
>Can anyone help????

[Mattus]

I want to execute another package inside a step that's inside a package -
through code.


"Some Dude" <some@dude.com> wrote:
>
>In your package there is an "Excute Package Task" task. This will let you
>run another package from within the current one.
>
>I hope that will help a little.
>
>Some Dude
>
>"Mattus" <LiquidCorn@hotmail.com> wrote:
>>
>>How do I execute an existing package within a package within an ActiveX
>Script
>>task??
>>
>>I want to call out to another package on my sql server during execution
>of
>>a loop within an ActiveX Script Task. Experimenting with the object model
>>of DTS has seems that it will allow me to create a package through code,
>>but all I want to do is execute a package that was already created with
>the
>>DTS designer in SQL Server. Can't a just says something like oPackage.Execute
>>("packagname") ??
>>
>>Can anyone help????
>