Issue :　　[OLE DB Destination [1346]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "Template.xlsx" failed with error code 0xC0202009.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.

Environment: SQL SERVER 2005 X64

                    Microsoft.ACE.OLEDB.12.0

Solution:  　

Reference:  http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/da076e51-8149-4948-add1-6192d8966ead/