SQLServerCentral.com Articles tagged Data Profiling

Data Profiling with T-SQL

Mon, 25 Feb 2013 07:00:00 UT

Need to understand new data? This article explains why - and how you can profile it efficiently

Dynamically Map Column Data Based on Column Pattern Profiling

Tue, 23 Feb 2010 07:00:00 UT

Tutorial on using Script Component, Regular Expression and derived Column Transform to dynamically map different source column types into the appropriate target column for address data.

Using The Data Profiler Task and FTP Task in SQL Server 2008 Integration Services

Thu, 28 May 2009 06:00:00 UT

See how the data preparation tasks within SSIS can be used to retrieve data or to validate the quality of data.

Data Profiling Column Functional Dependency T-SQL

Wed, 20 May 2009 06:00:00 UT

This article demonstrates Data Profiling Functional Dependency

New data profiling tools in SQL Server 2008

Fri, 06 Feb 2009 07:00:00 UT

New data-profiling tools native to SQL Server 2008 Integration Services such as the Data Profiling task and the Data Profiler Viewer help manage a business intelligence strategy.

Viewing the Data Profiling Task Data - SQL School Video

Tue, 27 Jan 2009 07:00:00 UT

It can be helpful in ETL operations to know what the distribution of your data is. Brian Knight shows how to use the Data Profiling task in this video.

Data Quality and Data Profiling

Thu, 01 Jan 2009 07:00:00 UT

David Loshin describes the benefits of the combination of the bottom-up aspects of data profiling with a top-down analysis phase for establishing criteria for data quality management.