I have 2 exceute sql tasks in my ssis package:
Execute SQL Task---> Execute SQL task1--->For each container(contains Execute SQL task)
I am getting following error on execution:
[Execute SQL Task] Error: Executing the query "Select distinct Email from table1,table2 where condition1 and condition2 and table1.ID=table2.ID " failed with the following error: "The type of the value being assigned to variable "User::test" differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object. ". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Description of Different controls used in SSIS Package:
1. First Execute SQL task: It Updates table 1's one column based on some condition in another column in same table.
2. I have the Result Set set to Full Result set in Execute SQL Tak1 , Also in the Result set I have it defined as: Result Name as 0 and Variable Name: User::test
3. And For Each Loop. I am iterating through the ADO Object Source variable called User::test
4. Also in the Excute SQL task inside For Each Loop Container i have Parameter Mapping saying variable name and parameter name: 0