-
'ODBC - Numeric Value out of range'
Help! I am bcp-ing in and out large amounts of data. It is a 2 column table, the 2nd column being a text field of length 16. In this text field is a large amount of XML data, about a page when I look at the text file. It has lots of text with lots of tags. It looks something like this "<Paper value = "hi" <!-- --> etc. etc".
I have no trouble BCP OUT but when I try to BCP IN, I get this error:
Starting copy...
SQLstate = 22003, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Numeric value out of range
SQLstate = 22003, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Numeric value out of range
SQLstate = 22003, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Numeric value out of range
SQLstate = 22003, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
Help!
Joyce
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|