HI, I have created ssis pkg to load the data from sap (source) to oracle destination. when I execute the pkg getting below error. in the destionation it is showing this error.(but connecitn string is succed)
SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "mis.mis" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
the error message is not informational enough. As it suggests did you check if there are any other error messages returned? The error seems to be in SAP source connection so it might be problem in setting it up inside source connection manager
hi visahk, thanks for ur suggestion. when I execute the package it is getting the error from Destionationside(Oracle) but connection manager is showing succeed [SSIS.Pipeline] Error: OLE DB Destination failed validation and returned error code 0xC020801C.
yes. it is show the error when i executed. it seems to be sap data structure is incompatibility issue.i have converted the data using data conversation.what is structure have to create in Oracle database ?still error persists