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 Integration Services
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. EchoLiu-MSFT 14,626 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.

    Was this answer helpful?

    0 comments

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.