SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSIS - Error: Failed to acquire connection


SSIS - Error: Failed to acquire connection

Author
Message
etl.laptop
etl.laptop
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: General Forum Members
Points: 1955 Visits: 116
A situation caused an error. I need to fix that.

Error -

[Execute SQL Task] Error: Failed to acquire connection "MyDBConnection". Connection may not be configured correctly or you may not have the right permissions on this connection.

Situation -

I got a package created in SSIS 2005 (32 or 64 bit, I don't know). When I imported the package into 2008, I got several warnings, which I ignored. I added some of my code to this package and then executed it. I now get the above error.

How do I fix it ?
kl25
kl25
Hall of Fame
Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)

Group: General Forum Members
Points: 3202 Visits: 1875
[b]I got a package created in SSIS 2005 (32 or 64 bit, I don't know). When I imported the package into 2008, I got several warnings, which I ignored. I added some of my code to this package and then executed it. I now get the above error.


You might check whether it's an OLEDB connection. In SSIS 2005, the native SQL Client for OLEDB connections is at 1. In SSIS 2008 it's SQL Client 10. When I've done similar upgrades, there were some connections that remained at 1 even after the automatic upgrade. They need to be changed to 10.
Phil Parkin
Phil Parkin
SSC Guru
SSC Guru (207K reputation)SSC Guru (207K reputation)SSC Guru (207K reputation)SSC Guru (207K reputation)SSC Guru (207K reputation)SSC Guru (207K reputation)SSC Guru (207K reputation)SSC Guru (207K reputation)

Group: General Forum Members
Points: 207561 Visits: 24203
etl.laptop (10/15/2013)
A situation caused an error. I need to fix that.

Error -

[Execute SQL Task] Error: Failed to acquire connection "MyDBConnection". Connection may not be configured correctly or you may not have the right permissions on this connection.

Situation -

I got a package created in SSIS 2005 (32 or 64 bit, I don't know). When I imported the package into 2008, I got several warnings, which I ignored. I added some of my code to this package and then executed it. I now get the above error.

How do I fix it ?



I'd start by double-checking the connection configuration and permissions. If you find a problem, perhaps you can post back with specific details.

Note that packages are neither 32- nor 64-bit. But they can be run in 32- or 64-bit mode. A bit like Word really - a .docx is a .docx.


Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.
etl.laptop
etl.laptop
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: General Forum Members
Points: 1955 Visits: 116
Phil Parkin (10/15/2013)

I'd start by double-checking the connection configuration and permissions. If you find a problem, perhaps you can post back with specific details.


I don't know which specific details I can post. Not sure where the problem lies. The permissions and configs seem okay.

As an aside, I just found a config file that can be used to set this troublesome connection. I imported it, but I don't know how to use it. This file has the connection properties that I need. How do I use this file and make it work ?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search