I have a csv file (FIXED Width) with one cloumn and I read that column as string data type and then covert to Numeric (10,0) using Data Conversion Task.
But I get this error when I run the pacakge:
The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data.".
I tried to redirect the error Rows and found out that, when every the column has "0" as a value its redirecting it. I am not able to understand why is it, not able to read 0 as numeric(10,0). Where it is able to load other values except "0" ( I have seen even -1, -1234 doesnt have any problem)
I enabled "Retain null values from the source as null values in the data flow" on the Flat file Source editor.
Anyone out there had experienced this? SSIS is wired.....