Home Forums Data Warehousing Integration Services Error: ForEach Variable Mapping number 0 to variable "ᶈ珈" cannot be applied RE: Error: ForEach Variable Mapping number 0 to variable "??" cannot be applied
vijay.katta
SSC Journeyman
Points: 79
More actions
October 7, 2015 at 5:22 am
#1831957
convert the datatype in the Execute Sql Task to match enumerator type. See the below statement
SELECT CAST(<columname> AS INT)
FROM <talename>