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: 2254
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.

Post Reply