and the format of my input data file is as follow:
123458962365 07-08-2005 a
567856984123 05-06-2009 b
910236985475 02-08-2003 c
356914589632 01-02-2000 d
now,whenever i m trying to run this in CMD...it gives me the error as:
SQLState = 42000, NativeError=4896
error= [microsoft][sql native client][sql server] Invalid column value from bcp client for colid 2
BCP copy in failed.....
So, now can anyone pleaseeeeeeeee tell me..how to deal with this????
any help will be greatly appreciated...