Variable uses an Automation type not supported in VBScript

• Mike Austin-398977

  Say Hey Kid

  Points: 697

  More actions

  January 26, 2007 at 2:08 pm

  #171189

  I get this error when I execute an ActiveX script.  Here is the offending line of code:

  If intFileCount <> intExpectedFileCount then

  Here is the code where these variables are referenced:

  Dim intFileCount

  intFileCount = 0

  intFileCount = intFileCount + 1

  Dim intExpectedFileCount

  intExpectedFileCount = DTSGlobalVariables("ExpectedFileCount")

  The Global variable intExpectedFileCount is defined as type int with an initial value of 39.

  Do I have to explicity CAST the global variable?  I fail to see where the Automation type is but, then again, I'm not that experienced in VBScript.

  TIA,

  Mike

• Erik Kutzler

  SSCarpal Tunnel

  Points: 4287

  More actions

  January 26, 2007 at 3:22 pm

  #685984

  2 options.

  1) Change the data type of the global variable from Int to Integer.

  2) Replace your code with this:

  intExpectedFileCount = CInt(DTSGlobalVariables("ExpectedFileCount"))

• mike gercevich

  SSCrazy

  Points: 2961

  More actions

  January 29, 2007 at 6:38 am

  #686120

  I have seen this error when you attempt to set a VBScript variant to a SQL Decimal without explicitly converting it to a Double.  HTH