This is going to be a quick post as it’s mainly a reminder to myself about how to deal with this error if I ever encounter it again in future (and knowing my luck, I will).
I recently inherited an Integration Services package and almost immediately ran into problems when trying to debug it. The error I received was “AcquireConnection method call to the connection manager failed” which is less helpful than it might be (thank you Microsoft!). After several pages of search results, I was lucky enough to stumble over Ginger Grant’s very useful blog post which pointed me to the project & packages’ Protection Level.
As Ginger says in her post: “News flash. DontSaveSensitive means what it says. It doesn’t save the password, so when you run the package, you have no password and therefore cannot acquire a connection.“. And like Ginger, the solution in my case was to set the levels to EncryptSensitiveWithUserKey.
Be First to Comment