Update a row in oracle using OLEDB command(SSIS)
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 getAn 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 helpUnder 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.
精彩评论