Anyone????????


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Anyone????????

  1. #1
    Mattus Guest

    Anyone????????


    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????

  2. #2
    Some Dude Guest

    Re: Anyone????????


    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????



  3. #3
    Mattus Guest

    Re: Anyone????????


    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????

    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center