I have a SSIS package transfer data from SQL Server to Oracle. The OLE DB Provider using is "Native OLE DB\Oracle Provider for OLD DB".
Inside the Visual Studio, everytime when I set the "AccessMode" of data flow task of the destination (Oracle table) to "OpenRowset Using FastLoad", it always prompt the following error,
Error 1 Validation error. Data Flow Task: Destination - TEST [19]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "DestinationConnectionOLEDB" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.test.dtsx00
It is no problem when testing the connection in "Connection Manager". Would anyone can suggest me the reason? Thanks.