Symptoms:

Executing an Oracle table results in an error message.

Error message:

Error during execution of package for <TableName>
SSIS Package: <TableName>
SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005
An OLE DB record is available. Source: "Microsoft SQL Server Native Client <VersionNumber>" Hresult: 0x80004005 Description: "Invalid date format".

There was an error with input column <ColumnName> (<Number>) on input "OLE DB Destination input" (<Number>). The column status returned was: "Conversion failed because the data value overflowed the specified Type.".

Underlying Cause:

The Oracle TIMESTAMP data type has a smaller minimum value than its equivalent in Microsoft SQL Server.  Trying to bring in Oracle TIMESTAMP values that are “smaller” than the minimum value of SQL’s DATETIME data type will result in an error.

Solution:

Check “Convert out of range dates to MS sql min/max date” to convert out-of-range Oracle dates to Microsoft SQL Server’s minimum DATETIME value, January 1^st, 1753.

Return to Oracle Troubleshooting Hub

Author: Doug Wynkoop