Removed Quotes but getting same error SQLState = 22005, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Invalid character value for cast spe
ification ThanksPTP

thomas.[Email Address Removed] wrote:
The problem appears to be that you have numeric datatypes which are in your input mode as strings.
If you remove the quotes from the numeric datatypes in your input file, you should be OK. If the whole file is representative of what you posted, you can probably remove all of the quotes from the file. Their only value is if the data organically contains what you are using as the column or row separators.

. . . Tom
On 04/23/2003 10:31:26 AM manage data wrote:
> 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





-----------------------------------------------------------------
Visit our Internet site at http://www.reuters.com

Get closer to the financial markets with Reuters Messaging - for more
information and to register, visit http://www.reuters.com/messaging

Any views expressed in this message are those of the individual
sender, except where the sender specifically states them to be
the views of Reuters Ltd.


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