I have exported LeadHistory data from Workbench into a local CSV. I am now trying to import that via SQL Server's import wizard, but am getting stuck on the
CreatedDate field. The wizard suggests the source field is of type DT_DATE and wants to map it to SQL Server's DateTime, yet throws an error on import.
Error 0xc0209029: Data Flow Task 1: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "Source - LeadHistory_csv.Outputs[Flat File Source Output].Columns[CreatedDate]" failed because error code 0xC0209084 occurred, and the error row disposition on "Source - LeadHistory_csv.Outputs[Flat File Source Output].Columns[CreatedDate]" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure. (SQL Server Import and Export Wizard)
I have tried various other date options for the source (reference):
All of these map to SQL Server's datetime, which is what we've used in the past.
A sample source value looks like this:
Any thoughts on how to get the import wizard to handle this? Do I need to pre-process the field and transform it?