DTSSource data type ?

  • I have a DTS package where I copy some columns and derive a column in the destination table based on a column in my source table (type numeric)

    When I run this package code I got an error Type mismatch

      If   DTSSource("Value")  < 115959  then

          DTSDestination("slice") = 1

       Else

          DTSDestination("slice") = 2

       End If

    When I do this it a conversion of DTSSource("Value") I've got the error

    The variable uses an automation type not supported in VB script

     If   int(DTSSource("Value"))  < 115959 then

          DTSDestination("slice") = 1

       Else

          DTSDestination("slice") = 2

       End If

    How van I use a comparison of DTSSource("Value") with a numeric value

  • Ok found the answer

    I've had to use the Clng function instead of int function

     If   clng(DTSSource("Value"))  < 115959 then

          DTSDestination("slice") = 1

       Else

          DTSDestination("slice") = 2

       End If

    Sorry to bother

    J

Viewing 2 posts - 1 through 2 (of 2 total)

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