Discussion Locked

MS SQL 7 passing global variable values

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have created a global variable in an activex script in a DTS process and I need to pass that value into a data transform process. I can do it in SQL 2000 with no problems but I need to downgrade the DTS package to a 7.0 version. Does anyone knowthe syntax in the data transform process?

3 replies

by glen_mcleod

The syntax for 7.0 is:

DTSGlobalVariables("myglobalVar").Value

to either get or set the value, or create the variable in the first place.

To use it in actual DTS process you'll have to use an ActiveX transform instead of the CopyColumn to get the variable's value and put it into the destination column:

DTSDestination("YourColumnNameHere") = DTSGlobalVariables("YourGlobalVariableHere").Value

Glen

by kennethx.r.haynes

I am aware of how to set and get global variable values in an ActiveX transform. The question was and still remains, is there a syntax that will allow me to pass a global variable value into a SQL 7.0 copy column data transform?

This discussion is closed to new replies.