I have a Dts package which I need to kick off from SSIS. In the past we have run this package from a bat file and set the global variables in the bat file.
How Can I set the Global Variables of the DTS Package in the SSIS Package.
I believe I am supposed to add them as inner variables and se the values there. however I cannot figure out how to change them in other words I can type them in in the task editor, but I can't change them based on runtime information.
the variables are not accessible as expressions, there is a field called inner gloabal variables in the properties pane, but it is all but useless. everything is disabled.
Please help me!!!