RE: How do I use BCP in SQL Server?
hey i have my data in the following format
Line 1:
000000004998152225|6783|1000|E|1110006042|000010|2006|03| 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |20060217
Line 2:
F01U002255 |6783|1000|E|1110003940|000010|2006|03| 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |20060217
Line 3
000000004998151567|6784|1000|E|1110006225|000090|2006|02| 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |20060216
I wrote following script to copy this data from .txt file to table in the server
[db_scpm-sql].[testing].[mska3] in "Z:\40_SCPM\80_SQL-server\80_Implementation\90_testdata\MSKA.txt" -c -t"|" -T -S FE0DBP97
but here it give me the following error. I tried with the format file option also, but it gives the same error.
Starting copy...
SQLState = 22005, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]Invalid character value for ca
st specification
SQLState = 22005, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]Invalid character value for ca
st specification
SQLState = 22005, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]Invalid character value for ca
st specification
Can anybody help me with this??
Any kind of help will be highly appreciated.
