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
