March 28, 2011 at 8:30 am
[OLE DB Source [1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "xxxxx" failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
What exactly I am doing:
1. I need to pull up a Data(Table) from Orcale DB and Load into SQL server DB
(Actually, Have a DTS package doing this, Need this to migrate to SSIS)
2. Orcale DB has Login and password, which are working fine
3. I am able to see the table in Orcale DB in Preview mode, if i starts to run the package then the above message appears.
Please feel free to ask questions if i am not clear.....
one more thing I don't have an idea about
1. MICROSOFT OLEDB Provider for Orcale and 2. Oracle Provider for OLEDB Providers
I strongly feel there may be something with this i think ....But i tried in connecting both of them, no progess...
Thank you for reading this...
March 28, 2011 at 11:42 pm
What is the protectionlevel of the package?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply