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?