A situation caused an error. I need to fix that.
[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.
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
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.