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
I have date like this in oralce 14-SEP-19 02.21.02.902547000 PMgetting 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 Read More
