How to add "Microsoft Connector for Oracle" to SSIS package programmatically via C#

Ken Mazur 1

I've not been able to successfully load an Microsoft Oracle Connector via C# script SSIS package generation. I can do it for OLEDB, no issue. How do I go about doing that same thing for Oracle?

Thanks
Ken Mazur

2 answers

ZoeHui-MSFT 32,821 Reputation points

2022-09-27T06:52:16.683+00:00

Hi @Ken Mazur ,

I did some online research that there is no sample code to add Microsoft Connector for Oracle via C#.

You may refer to Connecting to Oracle Database through C# about connect to oracle database with Oracle.DataAccess.dll.

Regards，

Zoe Hui

If the answer is helpful, please click "Accept Answer" and upvote it.
Please sign in to rate this answer.
Ken Mazur 1 Reputation point

2022-09-27T16:08:54.667+00:00

Thank you ZoeHui. I've done what this link displays many times over in a normal C# MVC project. What I'm dealing with is generating SSIS packages dynamically through C# Console app. So I need to dynamically create the Microsoft Connector for Oracle via C# script. The connector is from this URL: https://learn.microsoft.com/en-us/sql/integration-services/data-flow/oracle-connector?view=sql-server-ver16

Thank you for your response and I look forward to an answer from the community hopefully.

ZoeHui-MSFT 32,821 Reputation points

2022-09-28T01:20:19.423+00:00

Helped to add the tag for C# to invite more experts to see this. Hope they could give more ideas.
Sign in to comment
Olaf Helper 40,816 Reputation points

2022-09-28T09:37:05.507+00:00

I've not been able to successfully load an Microsoft Oracle Connector via C# script SSIS

How do you "load" the connection and which error message do you get? "Not able" is nothing we could work on.
Please sign in to rate this answer.
Ken Mazur 1 Reputation point

2022-09-28T13:58:18.12+00:00

By "load", I'm assuming you are talking about how have I attempted to script the dynamic generation of the Microsoft Connector for Oracle in my C# code. The answer to that is I haven't. I can't find any sample code anywhere online that instructs how this should be done. I'm hoping someone else in the community has figured it out and will post. I've been able to add the Microsoft Connector for Oracle manually in as both a package Connection Manager and as a project Connection Manager. But looking at the underlying XML doesn't give much indication on how to go about doing so via script.
Sign in to comment