Connection Error?

[ptheriault]

I have a x64, SP1 Developer edtion install of 2005. I have installed the ORAClient tools for 10G. I created a SSIS package to import data from an Oracle database as follows.

start -> run -> DTSWizard...
I walked through the steps to import the data using a query. I stored the password to the Oracle instance in the package.
I saved the package to MSDB.
I ran the package without any errors.

Now I've opened the package through BIDS and I get the following error.

Error at Cumulative_earned[Connection manager "SourceConnectionOLEDB"]: An OLE DB error has occured. Error code: 0x80040154.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".

Error at Data Flow Task[Source - Query[1]]: The AcquireConnection method call to the connection manager "SourceconnectionOLEDB" filed with error code 0xC0202009.

Additional Information:
Exception from HRESULT: 0xC020801C(Microsoft.SqlServer.DTSPiplineWrap)

Does anyone know what this means? I've tried to execute the saved package again from with Management Studio but it fails to valid.

Anyone?

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[Catadmin]

I believe this is the link. At least it states that it includes fixes not available in SP1, so I'm pretty sure it's the link.

http://support.microsoft.com/kb/918222

The hot fix MUST be applied in order, so make sure you check the readme file first, otherwise something will screw up.

Does this help?


Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[ptheriault]

thanks Cat

- Paul
- If at first you don't succeed, find out if the loser gets anything.