Devart Forums

Discussion forums for open issues and questions concerning database tools, data access components and developer tools from Devart
https://forums.devart.com/

Importing Oracle DATE data type loses time element

https://forums.devart.com/viewtopic.php?f=60&t=37841

Page 1 of 1

Importing Oracle DATE data type loses time element

Posted: Wed 10 Oct 2018 18:34
by Yanyong
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.

Re: Importing Oracle DATE data type loses time element

Posted: Fri 12 Oct 2018 10:22
by Pinturiccio
We have reproduced the issue. We will investigate it and post here about the results as soon as possible.

Re: Importing Oracle DATE data type loses time element

Posted: Wed 24 Oct 2018 12:02
by Pinturiccio
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.

Re: Importing Oracle DATE data type loses time element

Posted: Thu 25 Oct 2018 15:46
by Pinturiccio
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
All times are UTC
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/