troubleshooting Question

SSIS Error with OLE DB Command to Oracle

Avatar of SQLSearcher
SQLSearcher asked on
Microsoft SQL ServerMicrosoft SQL Server 2008SSIS
10 Comments1 Solution1299 ViewsLast Modified:
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.
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
ASKER CERTIFIED SOLUTION
Vitor Montalvão
IT Engineer
Join our community to see this answer!
Unlock 1 Answer and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros