An error occurs within different components (
SQL Task) when applying variables such as
User::sum for instance.
But there is manually no mismatch to see regarding datatypes. Is there a missing SQL Server 2005 Hotfix to install or another frequently occuring open issue to resolve?
[Execute SQL Task] Error: An error occurred while assigning a value to variable "sum": "The type of the value being assigned to variable "User::sum" differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object. ".
It works fine with SSIS 2012 but it is a requirement to deliver the same stuff in SSIS 2005. This is the reason concerning the old application version of SSIS.
Resolved: DB attribute was an
int and SSIS required a