Post reply

Unable to create the type with the name DTS.ConnectionManagerOracle.2

  • April 11, 2024 at 1:03 am

    #4409881

    We have installed & created the SSIS catalog on SQL Server2022 with standard edition.

    The visual studio 2019 is running on separate machine. When they try to deploy the project from visual studio2019 to SSIS, it is throwing error.

    The below error messages are logged in SSIS DB Failed to deploy the project. Fix the problems and try again later. Unable to create the type with the name DTS.ConnectionManagerOracle.2

    Do we need install oracle client on SSIS server or do I need to download Microsoft Connector for Oracle V1.3 on SSIS server. Is it requires only enterprise version or works with standard edition?

     

  • April 11, 2024 at 7:19 am

    #4409956

    you need both Oracle client and Microsoft Connector - but Microsoft Connector requires Enterprise edition - so if you have Standard you can't use it and you need to use the normal Oracle connections.

    and have a look at https://www.sqlservercentral.com/forums/topic/very-slow-performance-using-where-on-oracle-linked-server/page/2#post-4400726 - alternative way to native SSIS objects to work with Oracle if sending data to Oracle

  • April 13, 2024 at 10:19 am

    #4410824

    Thank you

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply