bcp problem

From: Hans (Hans_at_discussions.microsoft.com)
Date: 12/14/04 

Date: Tue, 14 Dec 2004 07:45:06 -0800

I am trying to import data from a file. The file has entries like

1437 "PJ_001" 3 "PJ/001 "
5746 "PJ_002" 3 "PJ/002 "

while the table is defined as

k int 4 nulls
f text 16 nulls
c int 4 nulls
p char 30 nulls

When I use command

bcp "MyDatabase.dbo.MyTable" in "D:\Development\MyDatabase\MyFile.txt" -c
-S"MyPc\MyInstance" -U"sa" -P"MyPass"

I get error message

SQLState = 22001, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]String data, right truncation

on every entry. Can anybody explain why, or even better, how to get this
working???

Thanks in advance!
Hans.

Relevant Pages

  • Re: I want my money back! (and lower taxes)
    ... Add a new entry to the list of sectors in src/lib/global/sect.c (can ... do I have to modify a total number of entries in some other ... of "comm" command, ... any other commodities. ...
    (rec.games.empire)
  • Re: table with double entries using owcolors from xcolor
    ... >j> all entries are multirows. ... >j> But if I use the \rowcolors command from the xcolor package I ... >j> absolutely need to have each double entry placed in one single row. ...
    (comp.text.tex)
  • Re: register SLP in WINS
    ... There is a command for adding a static entry to an NT 4.0 based WINS server. ... It is mentioned on page 532 of the CPDG. ... I have not had complete success with the entries that I added using this ...
    (microsoft.public.sms.setup)
  • SADB_X_SPDFLUSH message handling for latest version of IPsec
    ... Recently I found the behavior for the command "setkey -FP" is quite different for the latest version IPsec. ... After digging the codes, I found the state of the SP entries will be set as IPSEC_SPSTATE_DEAD, but the entries will not be unlink from the SPD. ... it's hard to tell whether the SP entry still takes effect since "setkey -PD" will not show its status. ...
    (freebsd-net)
  • Re: Solving the lib mismatch problem
    ... This section is pointed to by an entry in the section table with the ... The number of entries in the table is determined by DT_VERDEFNUM. ... This is an index into the string section referenced in the section ... Offset in the string section reference by the link in the section ...
    (comp.unix.programmer)