Global Variable out of range error in DTS

• Sridhar-137443

  Hall of Fame

  Points: 3762

  More actions

  November 29, 2004 at 3:46 pm

  #59815

  Hi,

  I have created a DTS package. I have used Exxecute Sql Task inside DTS package. In that Execute Sql task I want to store the result of select statement which is of type datetime in a global variable. so I have created a global variable and stored the value inside the global variable. but when i tried to display the global variable using activex script it is giving the error message "global variable ordinal '0'(base 1) is out of range". Can you please tell me what might be the problem?

  Thanks,

  Sridhar!!

• Jonathan Stokes

  SSCrazy Eights

  Points: 9861

  More actions

  December 2, 2004 at 4:34 am

  #532159

  Without looking at your script it's hard to tell. The syntax should be as follows:

  DTSGlobalVariables("variablename").value

  I don't know what you mean about 'tried to display the variable'. Where are you trying to display it?

  ---

  ------------------------------
  The Users are always right - when I'm not wrong!