March 30, 2009 at 5:34 am
Firstly, I should add, I've never used SSIS, not even slightly!
Right, with that out of the way, on to the problem...
I have a table with a varchar field with no validation, I now want to see how the records in this field score against a lookup table - I've seen some cool article which says this can be achieved via SSIS - seen screenshots where you add the lookup table etc. (http://www.sql-server-performance.com/articles/dba/data_cleaning_ssis_p1.aspx)
So, can anyone give me an newbie guide on how I can go about setting this up, armed just with my database connections, table names and no knowledge of SSIS?!
All this data flow and control flow stuff etc confuses me - all I wanna do is say take this column in this table, see which if any of the records in this lookup table it matches. Clearly as it's fuzzy, some score specifying how close it is to record X etc.
Any tips?!
March 30, 2009 at 5:49 am
:/
Just found out we are on Workgroup edition and this only runs on Enterprise or Developer editions :/
Back to the drawing board I guess.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply