Error:
Here we have come up with one more error from SSIS project recently practiced by student of MSBI training. This error has occurred in the Execute SQL Task component present inside “Foreach Loop” Container as it shows redcross mark on the component as shown in the image down below.
Now let see the exact error under Progress tab which says that the parameter cannot convert from String to Int32 data type.
Now in order to see where the issue has been caused open Execute SQL Task Editor Component under “Parameter Mapping” tab of Execute SQL Task as shown in the image down below.
Here we see that everything is in Int32 data type and we know that EmpName and EmpAdd cannot be integers but they should be strings.
Solution:
The solution was given by the trainer of MSBI training to the student suggesting to just change data type for EmpName and EmpAdd from “Int32” to “String” under Parameter Mapping tab.
After applying changes to data type now re-run the package. You will see all components running successfully with green mark as shown below.
