ssis data conversion failed. the data conversion for column returned status value 2
Hi All, I am struggling with some very simple but irritating issue from past fews days. I have a Flat file connection which is reading the CSV File and pushing the data in table. But my package is failing with error message "the data conversion for column returned status value 2". I Changed the Retain Nulls property in the properties of the Flat File Source in the Data Flow Task. I thought as my CSV Files contains Null value that might be creating the issue but still the same error exists. Can anyone suggests what can be done in such type of issue. Also FYI we are taking same kind of CSV files for 2 different countries.Anything need to be checked in terms of Page Code value do let me know..Please !!!!