ODBC LookUp Transformation SSIS 2005
-
Hey all!
I need to find records that exist/do-not-exist between two Databases.
1st database is SQL Server 2005 DB (Connected by OLE DB)
2nd DB (Connected by ODBC driver)
I Need to find which records in SQL Server exist in the 2nd DB.
As far as I know in a Lookup Transformation you cannot reference a table through an ODBC connection.. unless you're using SSIS 2008. I have looked and looked but decided to ask the experts, is there any way around this? Such as downloading a service package that updates SSIS 2005 to allow ODBC connection in data flow transformations that it originally didn't support?
Any help would be greatly appreciated!!
-
Hi,
There is no such update for SQL 2005 and don't expect one any time soon. You have three options:
1. Upgrade to SQL 2008.
2. Implement:
- Loading of ODBC lookup information into a dictionary object using script.
- Use another script in the data flow where you need the lookup information to check the dictionary object.
3. If you can use third-party solutions, check the commercial CozyRoc Lookup Plus component. It supports ODBC databases as source and many other features.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply