ETL and Data Integration tools - Modern ETL software for everyone

Good morning,

I have an import which continually rejects records with bad dates. I would like them to capture this data and deal with it afterwards, but it appears they are is always rejected, even if I set the error function to use a default date 01/01/1111.


Is they any way to accept these records and include them in the output table?

Thanks

The problem is that SQL server can handle data from January 1, 1753, through December 31, 9999 only for Datetime fields.

That leaves you only with two options

1 change field type to varchar
2 Use rejected records file (set batch size to 1 for sql server connection) and correct the data in the rejected records file and load it

Hope that helps,
John

John, thanks for the follow up and suggestions.

Regards,
Joe