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.
Importing Oracle DATE data type loses time element
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Importing Oracle DATE data type loses time element
We have reproduced the issue. We will investigate it and post here about the results as soon as possible.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Importing Oracle DATE data type loses time element
We have fixed the bug with truncating time for DATE columns in a SSIS package. We will post here when the corresponding build of SSIS Data Flow Components is available for download.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Importing Oracle DATE data type loses time element
New version of Devart SSIS Data Flow Components 1.9 is released!
It can be downloaded from https://www.devart.com/ssis/download.html or from Customer Portal (for users with valid subscription only).
For more information, please refer to viewtopic.php?t=37917
It can be downloaded from https://www.devart.com/ssis/download.html or from Customer Portal (for users with valid subscription only).
For more information, please refer to viewtopic.php?t=37917