Tuesday 10 April 2012

DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. (0xC0209303)

Whenever this error happens

SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.   failed with error code 0xC0209303


Check you connection string if the provider is
;Provider=sqlncli10.1

In my case the was because I had a connection string with Provider=SQLNCLI.1 from Integration 2005 and when I upgraded to 2008 didn't change it.

It took me along time to find this out hope it helps