开发者

Update a row in oracle using OLEDB command(SSIS)

开发者 https://www.devze.com 2023-02-14 14:00 出处:网络
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

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

Update a row in oracle using OLEDB command(SSIS)

When i test it, it succeeds

Update a row in oracle using OLEDB command(SSIS)

Now when i come to configuring the OLEDBCommand., I pass in the Connenction Manager

Update a row in oracle using OLEDB command(SSIS)

specify the command

Update a row in oracle using OLEDB command(SSIS)

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

Update a row in oracle using OLEDB command(SSIS)

thanks for the help


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.

0

精彩评论

暂无评论...
验证码 换一张
取 消