Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!
SSIS Error with OLE DB Command to Oracle
Hello Experts Exchange
I have a SSIS package that has a ADO datasource to MYSQL, it then does a lookup to Oracle, the match data then goes to a OLE DB Command to update the records.
The OLE DB Command is running this script.
But when I click Refresh in the OLE DB Command I get the following error message;
I have googled the error code 0x80040E30 , but have found nothing.
Can anyone suggest something I can try to get this working please?
Regards
SQLSearcher
I have a SSIS package that has a ADO datasource to MYSQL, it then does a lookup to Oracle, the match data then goes to a OLE DB Command to update the records.
The OLE DB Command is running this script.
Update SITE_INCOME
Set SI_AMOUNT_BANKED = ?,
SI_BGC_NO = ?
Where SI_ID = ?
But when I click Refresh in the OLE DB Command I get the following error message;
Error at Data Flow Task [OLE DB Command [99]]: SSIS Error Code DTS_E_OLEDBERROR. AN OLE DB error has occurred. Error code 0x80040E30.
An OLE DB record is available. Source "Microsoft OLE DB Provider for Oracle" Hrsult: 0x80040E30 Description: "Type name is invalid.".
Error at Data Flow Task [OLE DB Command [99]]: Unable to retrieve destination column descriptions from the parameters of the SQL command.
I have googled the error code 0x80040E30 , but have found nothing.
Can anyone suggest something I can try to get this working please?
Regards
SQLSearcher
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
I can see that you're using "Microsoft OLE DB Provider for Oracle". Don't you have an Oracle Client driver instead?
Hello Vitor
I have a Oracle ODBC driver but I have not got a OLE DB Oracle driver.
Where would I get that, and how would I install it??
Regards
SQLSearcher
I have a Oracle ODBC driver but I have not got a OLE DB Oracle driver.
Where would I get that, and how would I install it??
Regards
SQLSearcher
Should be in your Oracle Client installation media but you can also download it from Oracle's website.
Hello Vitor
The web site you have given me has Oracle 10g but I have 11g, do you know where I can find the OLE DB drivers for that?
Regards
SQLSearcher
The web site you have given me has Oracle 10g but I have 11g, do you know where I can find the OLE DB drivers for that?
Regards
SQLSearcher
You never mentioned that you needs a 32bit version.
Lucky that they have a similar webpage for 32bit :)
Lucky that they have a similar webpage for 32bit :)
Hello Vitor
I have downloaded the file and extract the files on my c drive and run the following command.
install.bat oledb C:\oracle true
but I don't have a Oracle OLE DB driver on my machine.
What should I do next to get it to work?
Regards
SQLSearcher
I have downloaded the file and extract the files on my c drive and run the following command.
install.bat oledb C:\oracle true
but I don't have a Oracle OLE DB driver on my machine.
What should I do next to get it to work?
Regards
SQLSearcher
Did you follow the install instructions that comes with the zip file?
Should be something similar with this one.
Should be something similar with this one.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial