As I have mentioned in some of my other posts I am using SSIS 2005 to replace an existing MS Access 2003 / VBA based ETL engine which I developed some years back. Part of my existing Access-based ETL performs a text search of the source records
and I am now attempting to replicate that functionality in SSIS (replicate in terms of the end-result and not necessarily the methods used to get to that end result). I have an idea of how I plan to go about this but since am relatively new to SSIS so
would greatly appreciate the feedback of those more experienced...
In the source (Sybase ASE15) database, there is an "object" table (not the actual table name but for illustrative purposes it will suffice). Within the object table there is a "description" column which is a char(60) datatype.
The description column simply represents a description of the object as defined by the source system end-user.
For my ETL solution I allow the ETL administrator to define one or many (1...n) key words or phrases which represent search criteria. These search criteria are stored in a reference table in my target SQL Server 2005 database (the same database to
which my ETL will transform results and store them). My objective, is as follows: For each of the 1...n search criteria defined, try and find th
View Complete Post