Share via

SSIS Script task connect to oracle

dinesh 41 Reputation points
2021-12-13T17:52:00.3+00:00

Hi, I want to connect oracle database using script task. I have used ado.net for connection manager. I tried different ways but didn't work.

SQL Server Integration Services
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 47,621 Reputation points
    2021-12-15T09:10:22.513+00:00

    using script task

    Which script task, SQL or .NET script?

    I tried different ways but didn't work.

    How did you try and what in detail means "didn't work"; do you get a error message (which one) or what happen?

    Please provide more details and information.

    Was this answer helpful?

    0 comments
  2. ZoeHui-MSFT 41,551 Reputation points
    2021-12-14T02:14:20.663+00:00

    Hi @dinesh ,

    You may refer oracle-parameterized-queries-in-sql-integration-services-ssis to see if it is helpful.

    In Step3 contains the code to use the Oracle connection manager defined in the SSIS package.

    Also take a reference for the reply in this thread.

    Regards，

    Zoe

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.