DTS Global Variables

[gromit114]

To Anyone,

I am curerntly designing a DTS package using SQL7. I need to be able to set a Global Variable using active x script as teh transfermation runs. I know i can do it using VB but do not want to do it this way. Any ideas!

 

[tlbroadbent]

Check out the SQLDTS website. It has some good articles and samples. The following page contains articles about dynamic manipulation of Task Objects, including Global variables.

http://www.sqldts.com/catlist.asp?nav=1,6,102,5

See faq183-962 for more DTS resources. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.