Hi Folks,
I am tring to import data using bcp command.
bcp LNTtest..Connections in Connections.txt -c -r \n -SQaserver -Usa -P
However I am getting the following error messages for three tables in my db:
Starting copy...
SQLState = 22001, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]String data, right truncation
SQLState = 22001, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]String data, right truncation
SQLState = 22001, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]String data, right truncation
SQLState = 22001, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]String data, right truncation
0 rows copied.
Please note that the design for the source and target tables is the same. Here is the table design for one of the tables:
CONNECTIONID varchar 8
DESCRIPTION varchar 50
RASENTRYNAME varchar 50
NETUSEDRIVE char 10
CONNECTIONTYPE int 4
STATUS char
RAS_USERID varchar 16
RAS_PASSWORD varchar 16
Any help would be appriciated.
Thanks,
-Meghna.Can you attach the file you are trying to import or a sample of the records ?|||Originally posted by rnealejr
Can you attach the file you are trying to import or a sample of the records ?
Here is the sample record for table connections:
Session4 Wan Connection 4 N/A 3 A
Session3 Wan Connection 3 N/A 3 A
Session2 Wan Connection 2 N/A 3 A
Session1 Wan Connection 1 N/A 3 B
Session5 Wan Connection 5 N/A 3 A
Session7 Wan Connection 7 N/A 3 A
Session6 Wan Connection 6 N/A 3 A
Session8 Wan Connection 8 N/A 3 A|||Which field is N/A being applied to ?|||What are the potential values for the first field "SessionX" ? Also, just take the first line from the file and use that line to test.|||Originally posted by rnealejr
Which field is N/A being applied to ?
N/A applies to rasEntryName. I also tried with only one row , I get the following:
Network packet size (bytes): 4096
Clock Time (ms.): total 15
Starting copy...
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Unexpected EOF encountered in BCP data-file
When tried with two rows, I get the following:
Network packet size (bytes): 4096
Clock Time (ms.): total 1
Starting copy...
SQLState = 22001, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]String data, right truncation
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Unexpected EOF encountered in BCP data-file|||What is your column seperator in your data file? Since you did not specify one, "-t", it needs to be a tab "\t".
Based on your example data, could you take one row and anotate the associated attribute? If you need to skip an attribute, you either need to provide a place holder in your data file OR use a format file, IMHO the second option works better.
The "Unexpected EOF encountered in BCP data-file" error is probably du to the last row NOT having a "\r" at the end, open the file and do a "CTRL+END", are you at the end of a line or an empty line?
Post back your thoughts and one of use will help.
没有评论:
发表评论