BCP.exe SQL Import - Invalid character value for cast specification
Posted on 2016-08-24
I have a couple of flat files, with roughly 10K records that I need to import to my MS SQL DB once of twice a week.
I don't have access to the actual server, just access via Management Studio.
So... I am using the BCP command to run this import. For now, I am testing this out on my local machine before using it in production.
The syntax is (sanitised):
bcp db.dbo.tableOld in E:\datafile.txt -c -r "0x0a" -S myserver-x
It gets through about 50+ records, then gives me the following error:
SQLState = 22005, NativeError = 0
Error = [Microsoft][ODBC Driver 11 for SQL Server]Invalid character value for cast specification
(10 of them, before failing)
I suspect this may have to do with the date field?
Anyway... not sure how to address?
Any assistance would be greatly appreciated.