SQL Server Performance

How to transfer parameters into „nested” packages?

Discussion in 'SQL Server DTS-Related Questions' started by mirek.grodzki, Sep 22, 2003.

  1. mirek.grodzki New Member

    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@
  2. satya Moderator

    I believe you can do with global variables, checkhttp://www.sqldts.com for code examples.

    HTH

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  3. mirek.grodzki New Member

    Unfortunately, I can't find any code example for my question.
    :-(

    MG
  4. satya Moderator

    Then apologies, other than that I don't see any other references.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  5. mirek.grodzki New Member

  6. satya Moderator

    I Appreciate the response with resolution.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com

Share This Page