I don't get any error message until I execute the package. Some dates are prior to 1753-01-01, so they need a datetime2 field in the database.

I discovered OLEDB destination component...