Friday, March 16, 2012 3:38 PM
I'm curious to know if there has been any improvement in Data Profiling from Microsoft now that there is a formal Data Quality Service?
I found a 2 year old article here Data Profiling tool . So is SSIS still the only solution that Microsoft offers?
I'd hate to have to use two different applications to do the basics of Data Quality: Profiling, Assessment and Cleansing. Seems like DQS only deals with the last 2.
- Edited by atragarz Friday, March 16, 2012 3:38 PM
Saturday, March 17, 2012 4:22 PMModerator
The hyperlink you gave is not working for me.
The SSIS Data Profiling Task and viewer remains the same in SQL Server 2012 as far as I know.
There is a tutorial blog series here: http://consultingblogs.emc.com/jamiethomson/archive/2008/03/02/ssis-data-profiling-task-part-1-introduction.aspx
DQS has a different style of data profiling, because it shows you the completeness, accuracy of the data values per each domain/column in the source data set, for example when you run a Cleansing activity in a Data Project. It doesn't do much drill in on the same screen though, so you can see the value patterns on the Results page of the activity.
Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance
Saturday, March 17, 2012 7:47 PM
In case you are interested in knowing about Data Profiling in DQS, see here: http://msdn.microsoft.com/en-us/library/hh213055(SQL.110).aspx.