Hi,
I am trying to improve performance on a DTS package. One of the step connects to an Oracle DB via OPENQUERY and brings in millions of records to update a 10000-row SQL table. I want to eliminate that step and convert the logic to data pump / DDQ. Since I only need to update about 10000 records, I like to create a lookup and pass the variable from ActivX transformation.
Lookup will be something like -
Select column1 from Schema.Table_Name where Column2 = ?
? - passed from transformation based on the row value in SQL table.
When I test the lookup, I am getting following message -
"Provider cannot derive parameter information and SetParameterInfo has not been called"
Any ideas?