April 23, 2004 at 8:07 am
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
April 23, 2004 at 8:48 am
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