Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SSIS Lookup Tool inoperative when using Parameterized Queries

SMerrill8Aug 9 2017 — edited Aug 10 2017

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?

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 7 2017
Added on Aug 9 2017
1 comment
3,468 views