Post reply

Variable uses an Automation type not supported in VBScript

  • September 21, 2004 at 10:27 am

    #60522

    VB Transformation:  DTSDestination("Field1") = DTSSource("Field2") * -1

    Error:  Variable uses an Automation type not supported in VBScript

     

    What doesn't it like?  How do I multiply by a negative?  It is always multiply by negative 1.  Would just getting the ABS do the same thing?

    Any feedback is appreciated.

  • September 21, 2004 at 11:28 am

    #523862

    I've come to find that this issues is occuring because DTSSource("Field2") is 0.  I want to make an

    IF ISNULL(DTSSource("Field2")) and DTSSource("Field2") = 0 Then

    but I keep getting and error.  Is my if formatted iincorrectly?

  • September 21, 2004 at 11:51 am

    #523867

    More specifics about my current error:

     

    Statement:  If  DTSSource("Field2") = 0 Or IsNull(DTSSource("Field2"))  Then

    Error:  Expected 'End' ... this is a run time error. This statement parses fine

  • September 22, 2004 at 4:24 pm

    #524081

    Can't tell much from that one line. Maybe you could post the entire script?

    --------------------
    Colt 45 - the original point and click interface

  • September 22, 2004 at 4:42 pm

    #524085

    Hey,

    It means there is no End If that it can find.  Make sure of that.

    In addition, if you still have problems, it may be that you want to check null and zero on separate lines (null first).

    Brian

  • September 23, 2004 at 8:26 am

    #524188

    I had to do a CINT on all integers coming it ... an ODBC data conversion issue.

     

    Thanks for your replies.

  • September 23, 2004 at 8:40 am

    #524194

    Hey,

    Try:

    IF ISNULL(DTSSource("Field2")) Then

      IF DTSSource("Field2") = 0 Then

        'Do whatever

      End If

    End If

    Did you find where a end if or end function may be missing?

    Brian

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply