Data Profiling using SQL Server 2012

Question

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.

Thanks

Answer 1

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.

http://msdn.microsoft.com/en-us/library/bb895263(SQL.110).aspx

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.

Thanks, Jason

---

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

Answer 2

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.

Thanks,
Vivek