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
ykhabins's avatar
ykhabins
Brass Contributor
Jan 25, 2021

Chunhua,

 

The existing Oracle Destination functionality is just for INSERT operations.

What is missing is that SSIS Execute SQL Task is not supported for Oracle Connector connections. This will allow to execute direct UPDATE, or call Oracle modules or procedures.

 

As of today, such attempt to execute SSIS Execute SQL Task gives an error, saying that you are not licensed for that, and contact DataDirect company  to buy a license.

 

 

Please add such functionality.