Forum Discussion
Oracle Datetime stamp conversion to SQL Server in SSIS
I have date like this in oralce 14-SEP-19 02.21.02.902547000 PM getting below err Inputs[OLE DB Destination Input]. The column status returned was: "Conversion failed because the data value over...
Inputs[OLE DB Destination Input]. The column status returned was: "Conversion failed because the data value overflowed the specified type.".I am trying to insert this into datetime data type in sqlserver table
Neils2401 the data type "datetime" as a date rang 1753-9999, see datetime (Transact-SQL) - SQL Server | Microsoft Learn
Do you may have a date before 1753 in Oracle? Then use the data type "datetime", see
Inputs[OLE DB Destination Input]. The column status returned was: "Conversion failed because the data value overflowed the specified type.".I am trying to insert this into datetime data type in sqlserver table
Neils2401 the data type "datetime" as a date rang 1753-9999, see datetime (Transact-SQL) - SQL Server | Microsoft Learn
Do you may have a date before 1753 in Oracle? Then use the data type "datetime", see
