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 overflowed the specified type.".
I am trying to insert this into datetime data type in sqlserver table
What conversion I need to apply to make this data pass and store in to SQL server table.
Versions: Sql server version 2016 and VS 2017 SSDT 2015
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
