使用OLEDB命令(SSIS)在Oracle中更新一行 [英] Update a row in oracle using OLEDB command(SSIS)

问题描述

我正在尝试使用OLEDB命令更新oracle数据库中的某些行
但是每当我尝试指定Sql命令时，这就是我得到的

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

我尝试使用

用于OLE的本地OLE DB \ Oracle提供程序 DB"提供商

我尝试更改为

"Oracle的本机OLE DB \ Microsoft OLE BD Provider"提供程序

但是我遇到同样的错误，请帮忙， 我正在使用ssis 2008

这是设置:连接管理器如下所示


当我测试它成功时

现在，当我要配置OLEDBCommand时，我会传入Connenction Manager


指定命令


现在，当我移动以配置参数时，什么也不显示，并且我收到此错误


谢谢你的帮助

解决方案

在输入和输出属性"下，您需要在OLE DB命令输入>外部列下添加列名称，然后它们将出现在列映射页面中.

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


When i test it, it succeeds

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


specify the command


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


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.

这篇关于使用OLEDB命令(SSIS)在Oracle中更新一行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！