May 11, 2011 at 7:55 am
Hi I have a table that contains the Oracle databases list and I need to connect to this databases to run the query on this databases to extract some info .What i did was i was using for each loop and in the expression i have assigned the server name with the variable that contains the oracle database but it's giving out an error saying that as below .but while connecting to each database manually its working fine .any help with this ..thanks in advance
TITLE: Package Validation Error
------------------------------
Package Validation Error
------------------------------
ADDITIONAL INFORMATION:
Error at Data Flow Task [OLE DB Source 1 [141]]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "HRDEMOBP.topology" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Error at Data Flow Task [SSIS.Pipeline]: component "OLE DB Source 1" (141) failed validation and returned error code 0xC020801C.
Error at Data Flow Task [SSIS.Pipeline]: One or more component failed validation.
Error at Data Flow Task: There were errors during task validation.
Error at OracleServer [Connection manager "HRDEMOBP.topology"]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80004005 Description: "ORA-12560: TNS:protocol adapter error".
(Microsoft.DataTransformationServices.VsIntegration)
------------------------------
BUTTONS:
OK
------------------------------
May 13, 2011 at 1:45 am
Check the following thread about the "ORA-12560: TNS:protocol adapter error" issue:
http://forums.oracle.com/forums/thread.jspa?threadID=74240&tstart=0
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 16, 2011 at 10:54 am
I have had that problem before.
I had to place breakpoints, step though the code and check the values.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 18, 2011 at 6:19 pm
Hi !
This issue was resolved once i installed 64 bit Oracle client
May 18, 2011 at 11:58 pm
RamSteve (5/18/2011)
Hi !This issue was resolved once i installed 64 bit Oracle client
Great that you were able to fix the issue and thanks for posting back!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply