SSIS error while executing the package the variable mapping is not applied
Error: ForEach Variable Mapping number 1 to variable "User::Production_Area_long" cannot be applied. Error: The type of the value (DBNull) being assigned to variable "User::Production_Area_short" differs from the current variable type (String). Variables may not change type during execution. Variable types are strict, except for variables of type Object.