Discussion Locked
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 glen_mcleod
oops, that last sentence should be all on 1 line...
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.
Trending Web Development posts
Sort by Trending
0 helpful
1 reply
0 helpful
1 reply
0 helpful
1 reply
1 helpful
3 replies
Question
Windows and macOS computers becoming slow or unstable after updates - what should I check first
0 helpful
1 reply