Importing Oracle DATE data type loses time element

Discussion of issues, suggestions and bugs of Devart SSIS Data Flow Components, our product line for building SSIS-based ETL solutions, performing data access to popular cloud applications and databases.
Post Reply
Yanyong
Posts: 1
Joined: Wed 10 Oct 2018 17:53

Importing Oracle DATE data type loses time element

Post by Yanyong » 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.

Pinturiccio
Devart Team
Posts: 2294
Joined: Wed 02 Nov 2011 09:44

Re: Importing Oracle DATE data type loses time element

Post by Pinturiccio » Fri 12 Oct 2018 10:22

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.

Pinturiccio
Devart Team
Posts: 2294
Joined: Wed 02 Nov 2011 09:44

Re: Importing Oracle DATE data type loses time element

Post by Pinturiccio » Wed 24 Oct 2018 12:02

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.

Pinturiccio
Devart Team
Posts: 2294
Joined: Wed 02 Nov 2011 09:44

Re: Importing Oracle DATE data type loses time element

Post by Pinturiccio » Thu 25 Oct 2018 15:46

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

Post Reply