SQL Import Text File Error: Code: 0xC02020A1, 0xC020902A, 0xC0202092
Posted on 2013-05-31
There's a SQL job that runs. It imports a text file. Runs every night. This morning it throws an error.
Error Code: 0xC02020A1
"Description: Data conversion failed. The data conversion for column "Column 26" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.". "
Error Code: 0xC020902A
"Description: The "output column "Column 26" (114)" failed because truncation occurred<c/> and the truncation row disposition on "output column "Column 26" (114)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component. "
Error Code: 0xC0202092
"Source: Data Flow Task Source - filename_txt  Description: An error occurred while processing file "filename.txt" on data row 43. "
I cut the file down twice and successfully imported the first 217 files (out of 757). Next I cut out the next 50 files - but came up with the same error as above.
Any ideas on this?