Viewing 15 posts - 1 through 15 (of 35 total)
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.
February 25, 2013 at 10:12 am
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...
July 10, 2012 at 8:19 pm
Sorry, too many scripts, you are right, send me an email email@example.com and I will send you the multi column version.
June 11, 2012 at 5:37 am
Sorry I should have noted the filters support wildcard, just put in a % character.
SET @columnname ='%'
June 11, 2012 at 5:16 am
Thanks for the comment, the script as is will do all multiple columns in a tables based on filter.
June 11, 2012 at 5:13 am
Hi can you provide more detail?
November 16, 2010 at 9:35 am
Thanks send me an email at firstname.lastname@example.org
August 2, 2010 at 9:11 pm
Sorry, went down. Send me your email to email@example.com, I will forward, I also have a 2008 version now.
March 18, 2010 at 1:38 pm
I have updated the article and code.
July 13, 2009 at 12:54 pm
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...
July 13, 2009 at 12:53 pm
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...
July 12, 2009 at 6:29 pm
Very interesting, I am stepping through the code, I am getting the same results. I will let you know.
June 10, 2009 at 3:06 pm
Thanks for the suggestions, I try them out.
June 10, 2009 at 9:25 am
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".
June 10, 2009 at 9:24 am
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...
June 10, 2009 at 7:31 am