Platform: Windows 7 Enterprise, SSIS on VS2015, 32-bit ODAC
Problem: When using the (32-bit) SSIS Lookup Tool with Oracle OleDB 11.2, I cannot choose the Advanced > Parameters command button without getting an 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)
In the SqlCommand property, my Oracle Query in the Lookup tool is simple:
SELECT * FROM TABLENAME WHERE A=:A AND B = :B
Of course I am using ? parameters in the SqlCommandParam property
SELECT * FROM TABLENAME WHERE A=? AND B = ?
Is there no way to map which parameter goes to which input?
Is this Oracle's bug , or Microsoft's bug?