Forum Stats

  • 3,769,895 Users
  • 2,253,029 Discussions
  • 7,875,233 Comments

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.

ADDITIONAL INFORMATION:

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.