Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Passing Variables from Parent to Child DTS Packages

Passing Variables from Parent to Child DTS Packages

Passing Variables from Parent to Child DTS Packages

thread961-1184247: Parent/Child Package - Sharing Information  and thread961-852677: Passing global variable to execute package task  -- I checked these and could not get the solution in them to work.

I inherited a SQL Server 2000 database and I need to use DTS. In particular, I need to take a value that I store in the Parent Package's Global Variables and pass it to a Child Package. I have been various forums but I cannot find anything that describes how you pass values from Parent to Child packages.

What I have tried so far is to create a global variable in the Child Pkg called "Received_Value". I have a global variable in the Parent called "Received_Value" (both of the same type). I load the parent variable with a value. In the Child package, on the "Outer Package Global Variables", I dropped it down and selected "Received_Value". I tried running it like this and nothing was passed.

Then I used a Dynamic Properties task to pass the Parent's Value to the Child's value. That did not work.

Then I tried using a Inner Package Global Variable and a Dynamic Properties task to pass the value to it. That did not work.

One of the problems I am having is that I don't know the difference between the Inner Package and Outer Package Global Variables in the Execute Package Task and there does not seem to be any documentation on it.

I scoured the SQLDTS.COM site but could not find an explanation of how it is done with the Execute Package Task. (they did have an explanation on ActiveX, but I would prefer not go that direction).

Can someone point me in the right directions? Thanks!


--- Tom  

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close