An error occurs within different components (ForEach & SQL Task) when applying variables such as User::cnt and 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 LONG

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.