VBScript within DTS

• Martin Vrieze

  SSCrazy

  Points: 2760

  More actions

  August 9, 2005 at 12:27 pm

  #66791

  The following VBScript generates an error during runtime even though it parses no problem in DTS...

  Function Main()

   DTSGlobalVariables("Counter").Value = DTSGlobalVariables("Counter").Value + 1

   DTSGlobalVariables("FileName").Value = DTSGlobalVariables("FileName").Value & CStr( DTSGlobalVariables("Counter").Value ) 

   DTSGlobalVariables("FileName").Value = DTSGlobalVariables("FileName").Value & ".MAIL"

   Main = DTSTaskExecResult_Success

  End Function

  Global var "Counter" = integer

  Global var "FileName" = string

  The error is..."Variable uses an automation type not supported in VBScript."

  "Error on Line 1"

  I used the VBScript Language builder in DTS to create this.

  Any thoughts?

• DSP-120308

  Hall of Fame

  Points: 3959

  More actions

  August 9, 2005 at 2:52 pm

  #580858

  Martin,

  Try this - DTSGlobalVariables("Counter").Value = CINT(DTSGlobalVariables("Counter").Value) + 1

   

  Good Luck,

  Darrell

• Martin Vrieze

  SSCrazy

  Points: 2760

  More actions

  August 9, 2005 at 3:02 pm

  #580862

  That worked.

  Thank you for your help.

• DSP-120308

  Hall of Fame

  Points: 3959

  More actions

  August 9, 2005 at 3:27 pm

  #580869

  I get lucky once in a while!!

  Glad to be of assistance.