January 2, 2007 at 9:44 pm
hi,
i have made a DTS Package in SQL and in that package i have a execute process task and a dynamic properties task and Activex script....
in this execute process task has pkzip25.exe file and it takes the variables from dynamic properties ... and activex is used to prompt for the input for variables..
i want to divide it into two layers so that execute process task will be in one package and other two in one package..
noe the proplem is that i want to read the variable that i give in the first package to read in the second package and execute the task by using execute package task ....
so the two packages will run in single package....
January 3, 2007 at 6:11 am
If I am understanding you, this is how I would do this. Some of this I think you are already doing.
Your process package has two steps and a couple global variables (named the same as what you used in your dynamic properties task). The first step is the dynamic properties task (probably the same as what you now have), followed by the process step.
In the top package is an activex script that gets the information and puts it all into the global variables. Then create an execute package task. In that task is a place to set the global variables. Just put the global variables in the "Outer Package Global Variables" tab. If the top and process packages have the same global variables (I think same type and all) then the process package will get the values from the top package.
Russel Loski, MCSE Business Intelligence, Data Platform
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply