|
|
|
SSC Journeyman
      
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 3:42 AM
Points: 80,
Visits: 846
|
|
|
|
|
|
Valued Member
      
Group: General Forum Members
Last Login: Tuesday, April 23, 2013 8:42 AM
Points: 55,
Visits: 29
|
|
Thanks for the excellent article, and the wonderfully useful script. I can already think of a number of instances where something like this could have been huge time savers.
One thing of note, there appears to be a character that got lost in translation along the way.
On Line 114: There appears to be a single quote (') that was incorrectly converted to value '#39;'
WHERE DATA_TYPE IN ('Date', 'DateTime', 'SmallDateTime', #39;DateTime2', 'time')
|
|
|
|
|
SSC Journeyman
      
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 3:42 AM
Points: 80,
Visits: 846
|
|
Thanks Ken, I will see if I can get this corrected. Glad that you find this script useful.
Adam
|
|
|
|
|
SSC Rookie
      
Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:48 PM
Points: 42,
Visits: 272
|
|
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=http://www.sqlservercentral.com/Authors/Articles/Ira_Whiteside/382777/][/url]
Ira Warren Whiteside
|
|
|
|