none
How to configure connection manager for OLE DB source for a Oracle connection? RRS feed

  • Question

  •  Able to create a connection in Visual Studio.Package works fine when executed in Visual Studio, but fails when executed using dtexec. Error is requested oledb provider is not registered. I am using Visual Studio 2017 to create dtsx, with target deployment of package to 2016.
    Wednesday, September 18, 2019 3:28 AM

All replies

  • Hi SSISLocal,

    What is your SSIS run-time environment version?

    Are you deploying to SSISDB Catalog?


    Wednesday, September 18, 2019 4:03 AM
  • Hello,

    Visual Studio is a 32 bit application and can utilize only 32 bit data Provider; have you installed ODAC as 32 bit Version?


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Wednesday, September 18, 2019 5:55 AM
  • Hi SSISLocal,

    Please try to set TargetServerVersion as SQL Server 2016.

    Best Regards,

    Mona


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Thursday, September 19, 2019 6:44 AM
  • Hi SSISLocal,

    Please remember to click "Mark as Answer" the responses that resolved your issue.

    This can be beneficial to other community members reading this thread. 

    Thank you.

    Regards,

    Mona



    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Monday, September 23, 2019 9:40 AM