Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2009-09-30 : 08:56:46
|
| I get this error when transferring a .csv file with alot of fields into a sql server table.All the fields get transferred fine except the one below which gives this message.The source column has values such as 0.001 and the destination column is varchar(50)Any thoughts on this error please?Thanks[Flat File Source [6796]] Error: Data conversion failed. The data conversion for column ""Field10"" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.". |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-09-30 : 09:38:19
|
| If you are sure that your destination columns have proper definition to hold the data, then can you check your data if it contains any special characters like '|' (pipe symbol) or a breaker space etc.This might cause the error. |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2009-09-30 : 09:42:05
|
| Does that make a difference because the destination column datatype is varchar(50). So that should contains anything, right?Thanks |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2009-09-30 : 09:43:53
|
| Hello again,I now placed a derived column to convert the filed in question into text stream data type.I now get an error on the ole db destination connection.Not sure why.The error is:Cannot create an OLE DB accessor. Verify that the column metadata is valid |
|
|
|
|
|
|
conversion