Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Passing Variables from Parent to Child DTS Packages

Status
Not open for further replies.

TomCarnahan

Programmer
Dec 7, 2002
123
US
thread961-1184247 and thread961-852677 -- 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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top