BCP Parameter for Unicode file

Hi,
Can any one suggest the bcp parameter for importing file , which is in unicode format, delimeted by tabs. i tried -w, -N all in vain :-(
TIA,
sudheerWhat do you mean that the input file is in unicode format?

I don't understand...|||Originally posted by Brett Kaiser
What do you mean that the input file is in unicode format?

I don't understand...

I meant the file is in Unicode format

i m using sql server 2000 .

Error message is

SQLState = 22005, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Invalid

character value for cast spec
ification

and string i used for bcp is

bcp <DBname>..<tablename> in

D:\a.dat -S<servername> -T -m0 -w|||http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_impt_bcp_9mwg.asp and verify the data in the file against the data type of the columns. This error usually indicates that the data is incorrectly formatted & is failing to get converted.

http://www.nigelrivett.net/BCP_quoted_CSV_Format_file.html for more help.|||Originally posted by Satya
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_impt_bcp_9mwg.asp and verify the data in the file against the data type of the columns. This error usually indicates that the data is incorrectly formatted & is failing to get converted.

http://www.nigelrivett.net/BCP_quoted_CSV_Format_file.html for more help.

Hi,
thnx for info, i solved the prob. the no.of columns in the datafiles and tht of the target table were not matching.

sudheer|||I still want to know what a unicode flat file is...|||I assume that a Unicode flat file is a fixed width columnar report that contains Unicode (16 bit wide characters) data.

-PatP