Forum Stats

  • 3,769,895 Users
  • 2,253,029 Discussions


Oracle OLEDB in SSIS Lookup can't parameterize

When using the SSIS Lookup tool with Oracle OleDB 11.2, and clicking the Advanced > Parameters command button

My Oracle SQL Statement is :

in the SqlCommand Property:

select * from table where a=:a and b=:b

In the SqlCommandParam Property:

select * from table where a=? and b=?

I get the following error;

Microsoft Visual Studio

Parameters cannot be extracted from the SQL statement. The provider might not help to parse parameter information from the statement.


Provider cannot derive parameter information and SetParameterInfo has not been called. (OraOLEDB)

Who's bug is this: Oracle's or Microsoft's?

This discussion has been closed.