What about the -r\r\n option, isn't there missin a comma ?

Or maybe -r,\n

I can't remember the exact syntax :(

\arni

-----Original Message-----
From: manage data [mailto:[Email Address Removed]
Sent: 23. apríl 2003 15:38
To: LazyDBA.com Discussion
Subject: RE: bcp utility error


Thanks for your response. I could load by using IMPORT wizard. no issues on column mismatch. ThanksPTP

"Long, Charles (euler:eti)" <Charles.[Email Address Removed] wrote: The message means that bcp is unable to store one of the values in the corresponding column of DOCK_RATE because they are incompatible with the datatype specified for that column. To be more helpful, we would need to see the table design. e.g. It may be that the final column has been specified as int and that '12.5' is consequently being rejected.

-----Original Message-----
From: manage data [SMTP:[Email Address Removed]
Sent: Wednesday, April 23, 2003 3:31 PM
To: LazyDBA.com Discussion
Subject: bcp utility error

Hi , bcp utility is killing me... from import/export wizard i can import data to table from my flat file but from BCP i am getting. Error = [Microsoft][ODBC SQL Server Driver]Invalid character value for cast speification Any idea ? (see below my bcp command and flat file , since import wizard is loading data i am not pasting table columns). bcp OM_OY.dbo.DOCK_RATE in DOCK.dat -C -t, -r\r\n -Smyserver -c -Umyuser -Pmypassword and flat file contains "66826","DOCK1","1","F","TL","LBS-Ch","10","12.5",

"66829","DOCK1","1","F","TL","LBS-Ch","10","12.5",
"66832","DOCK1","1","F","TL","LBS-Ch","10","12.5",
"66838","DOCK1","1","F","TL","LBS-Ch","10","12.5",
"66843","DOCK1","1","F","TL","LBS-Ch","10","12.5",
"66929","DOCK1","1","F","TL","lbs","10","12.5",
"66915","1","1","F","","","2","2",
"66917","1","1","F","","","3","3",
"65048","2","1","F","","cube","45","17",
"65991","1","1","R","","LBS-Ch","1","10",
"39302","1","1","F","","LBS","10","20", Thanks in advance PTP


---------------------------------
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.




---------------------------------
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
MS Sql Server LazyDBA home page