Adam, excellent article and my favorite topic.

I have several articles and scripts also on Data Profiling via SSIS(DataFlow script component) and also TSQL.

[/url]

Mr DeusExDatum is exactly "spot on" and I highly recommend that you follow him, he has very deep and extensive experience and I have had the pleasure in working with...

Sorry, too many scripts, you are right, send me an email iwhiteside@iwhiteside.com and I will send you the multi column version.

Sorry I should have noted the filters support wildcard, just put in a % character.

SET @columnname ='%'

Thanks for the comment, the script as is will do all multiple columns in a tables based on filter.

Hi can you provide more detail?

Thanks send me an email at iwhiteside@iwhiteside.com

Sorry, went down. Send me your email to iwhiteside@iwhiteside.com, I will forward, I also have a 2008 version now.

Martin,

I have updated the article and code.

Thanks

Ira

I agree but keep in mind many folks still rely on tsql. I have used SSIS extensively, but have found it has a bit of a learning curve. I wanted...

Update: Based on several excellent forum contribution’s I asked Michael Capes(friend with big brain) to review them and provide feedback. The result is a revision to the original script/article. The...

Very interesting, I am stepping through the code, I am getting the same results. I will let you know.

Thanks for the suggestions, I try them out.

Thank you, the translation came from some friends in New Delhi, what would be your translation for "Do, or do not. There is no try".

Yes, Jaro-Winkler will give more weight to the length of the string match from the beginning of the string. It should be more accurate the Levi, however the real challenge...