I am having an issue with uploading a txt file into an SQL table and one of the fields needs to go into a datetime column.
The issue is with column3 I have been into the advanced editor of the flat file source and set the output column to decimal and it fails.
The error I am getting is below:
Error: 0xC02020A1 at Materials Transfer, Flat File Source : Data conversion failed. The data conversion for column "Column 3" returned status value 2 and status text "The value could not be converted because of a potential loss of data.".
Error: 0xC0209029 at Materials Transfer, Flat File Source : SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "output column "Column 3" (48)" failed because error code 0xC0209084 occurred, and the error row disposition on
"output column "Column 3" (48)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
Error: 0xC0202092 at Materials Transfer, Flat File Source : An error occurred while processing file "D:\Development\r3_downloads\mat.txt" on data row 1.
Any help would be great.
View Complete Post