We help IT Professionals succeed at work.
Get Started

SSIS Error with OLE DB Command to Oracle

1,279 Views
Last Modified: 2016-02-22
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 = ?

Open in new window


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.

Open in new window


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
Comment
Watch Question
IT Engineer
CERTIFIED EXPERT
Distinguished Expert 2017
Commented:
This problem has been solved!
Unlock 1 Answer and 10 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE