Post reply

How to transfer parameters into „nested” packages?

  • September 23, 2003 at 1:49 am

    #106505

    I use DTS for transferring data in MS SQL SERVER.

    I would like to transform data in parts (one part for one month)

    I have 3 DTS packages: package1, package2, package3.

    There is another package (package4) which includes packages1, 2 and 3.

    I would like to execute packate4 with two parameters: date_from and date_to (to choose date for transforming). How to use those parameters from package4 in packages 1,2 and 3?

    How to transfer parameters into „nested” packages?

    Regs,

    mirek.grodzki@hogart.com.pl

  • September 23, 2003 at 5:25 pm

    #475508

    If you don't already, save the parameters to global variables. Then specify these global variables in the inner global variables tab on ExecutePackage task.

    Check out 'Execute Package Task' in BOL.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • September 24, 2003 at 5:06 am

    #475561

    Thanks.

    I've found solution for this problem.

    Results are at

    http://mirek.grodzki.webpark.pl/sql/dts.htm

    Regs,

    MG

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply