Home Forums Data Warehousing Integration Services SSIS - Error: Failed to acquire connection RE: SSIS - Error: Failed to acquire connection

  • October 15, 2013 at 12:19 pm

    #1658648

    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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.