Since most of the hits that I get on this blog are centered around SSIS, I thought I’d share this great post by
Cathi Mi. If you watch the vid, you should be able to handle the DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER error next time that it pops up.
Oh, by the way, I have a series on the greatest SSIS packages ever created coming soon. I’ll be posting a series of about 5 of them and they rule!
Lee
-------------------
WTF happened to the font on this blog posting???
http://blogs.msdn.com/b/cdm/archive/2011/05/11/why-can-t-my-package-acquire-a-connection-from-its-connection-manager.aspx
8fce7f49-ff86-4ac7-9177-ec89cc2c44f6|0|.0