Blog Post

SQL Server Integration Services (SSIS) Blog
2 MIN READ

General availability of Microsoft Connector for Oracle

Chunhua's avatar
Chunhua
Icon for Microsoft rankMicrosoft
May 25, 2020
Microsoft Connector for Oracle is now generally available.    Microsoft Connector for Oracle provides compatibility with Attunity Oracle Connector in functionality and performance. Packages desig...
Updated May 25, 2020
Version 1.0
stephanvr's avatar
stephanvr
Copper Contributor
Nov 17, 2021

Hi all,

 

we trying to migrate about 300 packages from VS2015/SQL Server 2016 to a cloud server with 2019.

 

Now we have a problem loading data into an Oracle TIMESTAMP(9) column.

The data viewer shows the correct data in CREATION_TSTP, data type is cast to (DT_STR,75,1252)

The package finishes without error and loads data into the oracle table:

but on the 'other' side there are no values in the column CREATION_TSTP, it's set to NULL.

The mapping and the data types: 

 

Exact the same package is running perfect under VS2015 and Attunity 4.

The display of the data types is identical DT_STR 75 on both sides under VS2015 and VS2019.

 

I tried casting it to various date types.

 

We are using/installed:

VS2019 16.11.6

Microsoft DataTools Integration Services 15.0.2000.170

Microsoft Connector for Oracle 15.0.2000.110 (both 32/64)

SQL Server 2019 (CU13)

Oracle Client 32/64

Oracle 19C

 

any ideas / hints?

 

Thanks

Stephan