Share via

DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER

Anonymous
2021-02-12T19:42:54.193+00:00

I have an SSIS package where Source: IBM DB2, Target: SQL Server. I have created a package in SSIS and able to run perfectly in my local machine. All connections work perfectly, data populates in the target tables. However, after deploying it to SQL Server the package fails with following error in screenshot. Checked the server it has IBM OLEDB drivers for DB2 installed in it. Please help me out. ![67551-image.png][1] [1]: /api/attachments/67551-image.png?platform=QnA

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,894 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,467 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. EchoLiu-MSFT 14,571 Reputation points
    2021-02-15T07:18:00.84+00:00

    Hi @Abdulrazzakh-2742，

    Welcome to the Microsoft SSIS Q&A Forum!

    If it can run successfully in SSIS, it means that the creation of the package is correct. But deployed in
    SQL Server returns an error, it should be a problem in your deployment process.

    Please tell me how you configure it in SQL Server？

    The following articles may be useful to you:
    Deploy SSIS Package Using SQL Server

    If you have any question, please feel free to let me know.
    If the response is helpful, please click "Accept Answer" and upvote it.

    Regards
    Echo

    If the answer is helpful, please click "Accept Answer" and upvote it.
    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.

    0 comments