I'm using bcp to import a flat file into an SQL Server 2005 database.
I'm running into a problem with datetime fields.
My format file field is specified as:
<COLUMN SOURCE="15" NAME="DATEOFSERVICE" xsi:type="SQLDATETIME"/>
My data file has dates formatted as:
However, some (many) are filled with 00000000
The 00000000 dates fail to import correctly due to a type mismatch.
Is there a way to specify my format file to handle the zeroed out dates? Or a way to tell bcp to enter a default if it comes across 00000000?