In DTS, I have an ActiveX that create a global variable and I am sure that variable has value. When it is
successful, it then goes next step which is a Transform Data Task between two SQL connections.
In the source tab, I use that global variable as parameter, but that variable can not be passed. I receive:
1. Run from Preview inside task:
No value given for one or more required parameters
2. Run entire DTS:
Invalid procedure call or argument: 'DTSSource'
Any thoughts? Thx