I developed a SSIS 2008 package to read from DB2 (using some id) into SQL server (using windows authenication). I face error when trying to execute, once I open and test connection for DB2 it works fine. But when tried to schedule via config xml file in a batch progam i am facing 'cannot acquire connection'
SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Stored_Src" failed with error code 0xC0202009.