samanw
May 10th, 2006, 02:40 PM
Hi All,
I am working on DTS to migrate some data from one Database to another.
1) I have a Master DTS Package.
2) I have 2 Child packages (Siblings) and they both executing inside the master package.
3) I want to keep one Global variabl which can receive/change the value in Master packate and as well as child packages.
4) I change the value in the Global variable GV_Counter in the package Child-1, Then I want to receive the value of GV_counter in Child-2 and also change the value.
Please tell me how to do this using Inner Package Variable and Outer Package Variable and where and how to use this properties/tasks.
(Microsoft book is sucks and doesnt explain it well)
Thanks in advance for your kindness :)
Bye,
Sam
samanw@hotmail.com
I am working on DTS to migrate some data from one Database to another.
1) I have a Master DTS Package.
2) I have 2 Child packages (Siblings) and they both executing inside the master package.
3) I want to keep one Global variabl which can receive/change the value in Master packate and as well as child packages.
4) I change the value in the Global variable GV_Counter in the package Child-1, Then I want to receive the value of GV_counter in Child-2 and also change the value.
Please tell me how to do this using Inner Package Variable and Outer Package Variable and where and how to use this properties/tasks.
(Microsoft book is sucks and doesnt explain it well)
Thanks in advance for your kindness :)
Bye,
Sam
samanw@hotmail.com