Can anyone help me understand how to access global variables passed from a DTSRUN command to the DTS?
The dtsrun statement is as follows:
dtsrun /S volcano /E /N dts_name /A foo:3=9999999
The DTS "dts_name" runs the following query:
SELECT * FROM table_name
where var1 is null and var2= ????global_variable_here????
Tks for any input.
Bst Rgds
_PC
The dtsrun statement is as follows:
dtsrun /S volcano /E /N dts_name /A foo:3=9999999
The DTS "dts_name" runs the following query:
SELECT * FROM table_name
where var1 is null and var2= ????global_variable_here????
Tks for any input.
Bst Rgds
_PC
