All geek questions in one place

SSIS Error Failed Connection

We have an SSIS package that runs from a web service. Everything works fine in the Dev environment, but in the QA environment, I get the following error when I try to run the package: "Failed to get the connection [ConnectionName]. The connection may not be configured correctly or you may not have rights to this connection."

The connection uses SQL input, not integrated. The entrance itself has the appropriate privileges. The SSIS package is located on the file system, not on the SQL server. I used DTCPing and everything is perfectly checked between the SQL server and the Utility server. Unfortunately, I know very little about SSIS, and I lost a bit, which can be a problem. Any suggestions would be greatly appreciated.

+4
source share
3 answers

I finally solved the problem and it was due to my MSDTC settings. Although MSDTC was enabled, I had to enable the following settings:

  • DTC Network Access
  • Allow Remote Client
  • Allow Inbox / Outbox
  • Enable TIP
+4
source

When using the "foreach loop" container in the SSIS package, we got this error after processing 3K + files ... By setting the RetainSameConnection connection property to TRUE, we were able to move over 32K files without any additional problems.

+1
source

I had a similar problem. I created a task to run the SSIS package, which I previously added to the SSIS directory on this server.

I solved this by going to the Job Step > Configuration > Connection Managers > For each connection, I had to specify a password and set RetainSameConnection = True.

I'm not sure if RetainSameConnection is necessary

0
source

Source: https://habr.com/ru/post/1313891/

More articles:


All Articles