Update a row in oracle using OLEDB command(SSIS)

oracle oledbcommand
Brian Paul picture Brian Paul · Mar 2, 2011 · Viewed 15.5k times · Source

I am trying to update some rows in an oracle Database, using an OLEDB Command
but whenever i try specifying the Sql Command this is what i get

An OLEDB record is available. Source: "OraOLEDB" Hresult:0x80040E51 Description:
"Provider cannot derive parameter information and
 SetParameterInfo has not been called."

I have tried using

"Native OLE DB\Oracle Provider for OLE DB" provider

and i tried changing to

"Native OLE DB\Microsoft OLE BD Provider for Oracle" provider

but i get the same error, please help, I am using ssis 2008

Here is the setup : The Connection Manager is as below
enter image description here

When i test it, it succeeds

enter image description here



Now when i come to configuring the OLEDBCommand., I pass in the Connenction Manager
enter image description here

specify the command
enter image description here

now when i move to configure the parameters, nothing is displayed and i receive this error
enter image description here

thanks for the help

Answer

xefere picture xefere · Mar 11, 2011

Under Input and Output Properties you need to add the column names under OLE DB Command Input > External columns, they will then appear in the column mappings page.

Related questions

Get list of all tables in Oracle?

How do I query an Oracle database to display the names of all tables in it?

Read More
How do I limit the number of rows returned by an Oracle query after ordering?

Is there a way to make an Oracle query behave like it contains a MySQL limit clause? In MySQL, I can do this: select * from sometable order by name limit 20,10 to get the 21st to the 30th rows (skip the …

Read More
ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

We have an application running locally where we're experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I've tested the connection using TNSPing which resolved correctly and I tried SQLPlus to try …

Read More