Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Passing values across packages

Author  Topic 

segopal
Starting Member

1 Post

Posted - 2004-05-12 : 18:55:27
Hi,

I have been using DTS and i have been successful in passing values from a parent package to the child package. I was able to do this by using the DynamicPropertiesTask and the ExecutePackageTask(setting global outer variables).

Can I pass values from the child package back to the parent package? is it possible, if so, how?


thanks
Sesh

timmy
Master Smack Fu Yak Hacker

1242 Posts

Posted - 2004-05-12 : 23:27:25
Sesh,

It is possible - via ActiveX script

objPackage.Parent.GlobalVariables("thisVar").Value = "new Value"

I haven't tested this, but I recall doing something very similar some time ago. You can check out BOL for more info.

HTH,

Tim
Go to Top of Page
   

- Advertisement -