Pasquale
2009-07-31 10:48:01 UTC
I need to map correctly the SSIS variable datatype with the datatype of a
column returned from a T-SQL query. Does exist a prospectus about this
subject?
F.e. I have this error:
"The type of the value being assigned to variable "User::..." differs from
the current variable type. Variables may not change type during execution.
Variable types are strict, except for variables of type Object. "
I have mapped my SSIS variable with the returned column of a query inside
Execute SQL Task. This column is a numeric(9,0) identity.
Thanks
column returned from a T-SQL query. Does exist a prospectus about this
subject?
F.e. I have this error:
"The type of the value being assigned to variable "User::..." differs from
the current variable type. Variables may not change type during execution.
Variable types are strict, except for variables of type Object. "
I have mapped my SSIS variable with the returned column of a query inside
Execute SQL Task. This column is a numeric(9,0) identity.
Thanks