November 15, 2008 at 9:31 am
Hello. I am having a problem when i try to insert data in an sql server 2005 database from a delimited text file. The error i m getting is the error 0xc02020a1:"Data convertion failed. The data convertion for column "201" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page". Any help would be much appreciated!
December 3, 2008 at 8:03 am
Are you using bcp or BULK INSERT?
201st column - yikes!
Do you have any documentation for the data you are inserting? ie..Does the 201st column data type in the documentation match up with the 201st column of your table definition? In other words, make sure you are not trying to insert varchar data into an integer!
If you have no documentation, then you'll have to load it into Excel, maybe or some other tool to read the delimited data and review the data in column 201 to make sure it matches up to your data type in the table.
We had to go through a similar task here recently, although eventually documentation arrived from the vendor and the change was made within a matter of minutes.
February 24, 2009 at 9:15 am
Also check if you matched columns correctly...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply