Update a row in oracle using OLEDB command(SSIS)

Question

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

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

specify the command

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

thanks for the help

Could you post the source code where you are making the connection and trying to perform the update with the command object? — Doug Porter, Mar 03 '11 at 05:01
@Dougman I added the screenshots of how i receive the error, please check above — Brian Paul, Mar 03 '11 at 09:46

score 11 · Accepted Answer · answered Mar 11 '11 at 06:31

11

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.

answered Mar 11 '11 at 06:31

xefere

126
1
2

Very late to the party here, but I just discovered that spaces in the parameter name are allowed in SSIS (and even defaulted with `Column 1`, etc.), but are not recognized by the Oracle provider. – Lathejockey81 Sep 06 '16 at 19:05

Update a row in oracle using OLEDB command(SSIS)

1 Answers1

Linked