Home » Developer & Programmer » Data Integration » SSIS Issue Connecting to Oracle - 0x80040e51 / "cannot derive parameter, SetParameter not called" (Oracle 11g.2.0.4.0, SQL Server Data Tools (SSIS) 2017 )
SSIS Issue Connecting to Oracle - 0x80040e51 / "cannot derive parameter, SetParameter not called" [message #668601] Tue, 06 March 2018 10:52 Go to previous message
edgeofblade
Messages: 1
Registered: March 2018
Junior Member
I'm hoping there will be some love for an SSIS junkie who is new to the Oracle world. I'm upgrading SSIS packages from 2008 to 2017 and having a persistent issue with getting Oracle sources to respond to... well, anything.

If you search for this from the SSIS end of the spectrum, the answer seems simple: Oracle connections don't like "parameters" in SSIS and we should concatenate user variables in expressions into our SQL. Except, in this case, I don't have any parameters to speak of in the query. In fact, I can reduce the query to a bare test query to ensure that, and yet I still get 80040e51: "Provider cannot derive parameter information and SetParameterInfo has not been called. (Microsoft OLE DB Provider for Oracle)"

If we create all new packages, in a new project, with a new connections, it still occurs.

Any thoughts? Anything to be done on the DB side?

[Updated on: Tue, 06 March 2018 11:07]

Report message to a moderator

 
Read Message
Read Message
Previous Topic: password in the OdiSftpPut object
Next Topic: ODI installer version 10.1.3.5 Unix compatibility
Goto Forum:
  


Current Time: Tue Jan 21 09:14:30 CST 2020