I have a Data Driven Query Task where my source is a SQL query. I have read
that I can specify parameters for this SQL query and map global variables to
them, however, when I click the Parameters button on the Source tab I get
the following error.
Error Source: Microsoft OLE DB Provider for Oracle
Error Description: Provider cannot derive parameter information and
SetParameterInfo has not been called.
What do I have to do to make this work? It does work if I specify Microsoft ODBC Driver for ORacle, but not if I specify Microsoft Data Link. I want to use the Data Link so I can use a UDL file. Any help is appreciated.