Hi,
I have to do a lookup in a table that I can only access through ODBC. However it seems the lookup component only allows an OLE DB connection manager.
Is there any way to do an ODBC lookup ?
thanks in advance ...
Not that I have seen. You have 2 other options though: 1. Use a script component and write code (connect and pull the table in memory in the preexecute, use lookups to the table in memory in the ProcessInputRow section). 2. Add a DataReader source and sort + join with the join operator. Which one is best to use depends on your situation. Neither of them is ideal - option 1 in my experience is usually the fasted but obviously more work to develop.
No comments:
Post a Comment