Hi,
I have a SQl task that runs a query that is assigned to an Object type variable. There are 4 columns being returned by this query. First 3 are string and last is a tinyint. Then in a Foreach loop I use Foreach ADO Enumerator to extract the rusults out from this Object variable. In the Variable Mapping page I list variables to put each of the 4 column values into. The 4th column (tinyint datatype) I am assigning to a variable that I defined with DataType Int16. Also, in my Loop I have SQL task in which I created a Parameter using this Int16 variable as a source and gave it a "numeric" datatype (this is the closest type avialable in drop down).
When I run I get an error:
Error: The type of the value being assigned to variable "User::varGetLastModDate" differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object.
Please help.. what should I set my variable type to?
I have a SQl task that runs a query that is assigned to an Object type variable. There are 4 columns being returned by this query. First 3 are string and last is a tinyint. Then in a Foreach loop I use Foreach ADO Enumerator to extract the rusults out from this Object variable. In the Variable Mapping page I list variables to put each of the 4 column values into. The 4th column (tinyint datatype) I am assigning to a variable that I defined with DataType Int16. Also, in my Loop I have SQL task in which I created a Parameter using this Int16 variable as a source and gave it a "numeric" datatype (this is the closest type avialable in drop down).
When I run I get an error:
Error: The type of the value being assigned to variable "User::varGetLastModDate" differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object.
Please help.. what should I set my variable type to?
