April 24, 2002 at 9:47 am
All,
I'm trying to import data in to a table but I keep getting the following msg:
SQLState = 22001, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]String data, right truncation
SQLState = 22003, NativeError = 8115
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error converting numeric to data type varchar.
SQLState = 01000, NativeError = 3621
Warning = [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
I've tried using the Import/Export Utility (going from Server A to Server B and using a text file as my source) and BCP. If I write an insert statement for the exact same data, I have no problems. Has anyone seen this before? Any help would be greatly appreciated.
Darias Brown
Landstar Systems
April 24, 2002 at 12:31 pm
You might want to let us know what the data looks like, the field types and lengths etc. For instance with text fields if you use BCP you do get truncation problems and you may need a service pack to take care of the problem.
The error you are mentioning seems to indicate a mismatch between the source and target fields, you can find this by looking at the mappings while using DTS.
are bcpthere are known problems Are any of the fields strings longer than
April 24, 2002 at 12:57 pm
Can you post your bcp command line and if using a format file post it's contents?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply