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)
 How to assign outer global variables to inner's

Author  Topic 

tutufool
Starting Member

14 Posts

Posted - 2006-11-07 : 04:12:56
I have a package which will call a couples of "execute package task".
so I want to init the inner package's globle varibles, how can I do that with an ActiveX script?

Actually, I want to know how to get the inner package object, so I can:
oPkg.GlobalVariables("ChildVar").Value = DTSGlobalVariables("ParentVar").Value

thanks!!!

mightypenny_ph
Yak Posting Veteran

54 Posts

Posted - 2006-11-08 : 21:53:52
you simply drag the global variable object in the left side of the ActiveX window pane... you can assign and set the value of the variable with that...

SlayerS_`BoxeR` + [ReD]NaDa
Go to Top of Page

mwjdavidson
Aged Yak Warrior

735 Posts

Posted - 2006-11-13 : 08:15:49
It looks like you're almost there. The following link should help you out:[url]http://www.sqldts.com/default.aspx?215[/url]

Mark
Go to Top of Page
   

- Advertisement -