Importing Oracle DATE data type loses time element
Posted: Wed 10 Oct 2018 18:34
I have a problem using SSIS Data Flow Component for Oracle to import data from Oracle 8.1.7 DATE column to SQL Server 2014 DATETIME column. The time element in the source data does not show up in the destination column.
Devart SSIS Data Flow Components 1.8.786. Direct connect (no Oracle client).
My 64-bit PC runs Windows 10 version 1703.
SSDT is on Visual Studio Enterprise 2017 version 15.8.6.
Devart SSIS Data Flow Components 1.8.786. Direct connect (no Oracle client).
My 64-bit PC runs Windows 10 version 1703.
SSDT is on Visual Studio Enterprise 2017 version 15.8.6.