-
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.
Thanks.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|