Set a global variable from another package

[JVZ]

I have a package that I already created, rather that creating a copy of that package I wanted to call it from another package. I figured out how to call and execute that package from another package. My problem is now before executing the calling package I need to set a global variable locating in the calling package...Does anybody know how to perform this task?

 

[JohnDTampaBay]

Right-click on the Execute DTS package task to open the Properties dialog box. Check out the two tabs for global variables. You may have to use an ActiveX script before the package call to dynamically change this property on the fly.

From BOL - Execute Package Task Properties (Child Package Globals Tab):

Use this tab to specify global variable information that will be passed to the Data Transformation Services (DTS) package to be executed. Make sure that the child package contains definitions for the global variables specified here or the Execute Package task will fail.

Information about global variables is displayed in each row of the Variables table. The buttons at the bottom of the table control the addition or deletion of global variables. You can select a cell in the table to enter or change information.

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.

 

[JVZ]

Thanks Angel for the reply...However I looking to change/set the value using ActiveX. I current excuting the child package using an ActiveX Script.