Hey all,
I'm having trouble using BCP (version 12.0.2000.8) to copy data into my Azure SQL database from a large csv file (~500MB w/300K rows). I don't do this kind of stuff very often so I hope I'm missing something obvious.
I'm using bcp with a format file and the tool doesn't like the standard ISO 8601 datetime string. For example:
2015-06-22T15:00:15.000Z
I've googled around and found some older articles about ODBC not supporting the format and others that indicated newer versions didn't have the problem.
Any ideas on how to get BCP to accept the standard date format? If not, is there an alternative to using BCP to get data in?
----- Ed