DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager

Troubleshooting: SSIS Package Execution Using SQL Server Agent (go thru the following link)
http://msdn.microsoft.com/en-us/library/dd440760.aspx

And also go thru the following link for possible causes of DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER error

http://msdn.microsoft.com/en-us/library/cc627376(v=SQL.100).aspx