Blog Post

SQL Server Integration Services (SSIS) Blog
3 MIN READ

Microsoft Connector for Oracle is released for SQL Server 2019 Preview

Tim.Chen's avatar
Tim.Chen
Icon for Microsoft rankMicrosoft
May 14, 2019
Microsoft Connector for Oracle  is the replacement of Attunity Oracle Connector starting from SQL Server 2019 and now it is released for preview. Microsoft Connector for Oracle provides compatibility...
Updated May 14, 2019
Version 1.0
ShawnBailey's avatar
ShawnBailey
Copper Contributor
Sep 13, 2023

Tim.Chen ,

 

I have a working Oracle Connection Manager.  Is there anyway to use the connection manager directly from a Script Task instead of a Data Flow task.  I am reading about 60 SQL statements from a list of files in a directory, and replacing the database name on each iteration.  I have used the following, but I cannot seem to instantiate the connection manager in a script task.  It is a lot of work to create source and destination DataFlow tasks.

 

using (SqlConnection conn = Dts.Connections["Oracle Connection Manager"].AcquireConnection(Dts.Transaction) as SqlConnection)

using (OleDbConnection conn = Dts.Connections["Oracle Connection Manager"].AcquireConnection(Dts.Transaction) as OleDbConnection)

using (OdbcConnection conn = Dts.Connections["Oracle Connection Manager"].AcquireConnection(Dts.Transaction) as dbcDbConnection)

 

What kind of connection object is output from the Connection Manager, how would I access it programmatically.