blogs.conchango.com

Browse by Tags

• katmai
• Microsoft
• SSIS

• SSIS: Data Profiling Task: Part 9 - Value Inclusion

  In this blog entry I am going to outline the function of the Value Inclusion profile request in the new Data Profiling Task in SQL Server 2008. BOL states about this profile request: Computes the overlap in the values between two columns or sets of columns. Read More... Posted 07 March 2008 05:23 by jamie.thomson | 1 Comments Filed under: SQL Server Integration Services, SSIS, Microsoft, katmai, sqL server 2008, Data Profiling

• SSIS: Data Profiling Task: Part 8 - Candidate Key

  In this blog entry I am going to outline the function of the Candidate Key profile request in the new Data Profiling Task in SQL Server 2008. BOL states about this profile request: Reports whether a column or set of columns is a key, or an approximate Read More... Posted 04 March 2008 04:21 by jamie.thomson | 3 Comments Filed under: SQL Server Integration Services, SSIS, Microsoft, katmai, sqL server 2008, Data Profiling

• SSIS: Data Profiling Task: Part 7 - Functional Dependency

  In this blog entry I am going to outline the function of the Functional Dependency profile request in the new Data Profiling Task in SQL Server 2008. BOL states about this profile request: Reports the extent to which the values in one column (the dependent Read More... Posted 03 March 2008 03:44 by jamie.thomson | 5 Comments Filed under: SQL Server Integration Services, SSIS, Microsoft, katmai, sqL server 2008, Data Profiling

• SSIS: Data Profiling Task: Part 6 - Column Value Distribution

  In this blog entry I am going to outline the function of the Column Value Distribution profile request in the new Data Profiling Task in SQL Server 2008. BOL states about this profile request: Reports all the distinct values in the selected column and Read More... Posted 03 March 2008 02:19 by jamie.thomson | 2 Comments Filed under: SQL Server Integration Services, SSIS, Microsoft, katmai, sqL server 2008, Data Profiling

• SSIS: Data Profiling Task: Part 5 - Column Statistics

  In this blog entry I am going to outline the function of the Column Statistics profile request in the new Data Profiling Task in SQL Server 2008. BOL states about this profile request: Reports statistics, such as minimum, maximum, average, and standard Read More... Posted 02 March 2008 22:49 by jamie.thomson | 4 Comments Filed under: SQL Server Integration Services, SSIS, Microsoft, katmai, sqL server 2008, Data Profiling

• SSIS: Data Profiling Task: Part 4 - Column Pattern

  In this blog entry I am going to outline the function of the Column Pattern profile request in the new Data Profiling Task in SQL Server 2008. BOL states about this profile request: Reports a set of regular expressions that cover the specified percentage Read More... Posted 02 March 2008 21:24 by jamie.thomson | 2 Comments Filed under: SQL Server Integration Services, SSIS, Microsoft, katmai, sqL server 2008, Data Profiling

• SSIS: Data Profiling Task: Part 3 - Column Null Ratio

  In this blog entry I am going to outline the function of the Column Null Ratio profile request in the new Data Profiling Task in SQL Server 2008. BOL states about this profile request: Reports the percentage of null values in the selected column. This Read More... Posted 02 March 2008 20:58 by jamie.thomson | 6 Comments Filed under: SQL Server Integration Services, SSIS, Microsoft, katmai, sqL server 2008, Data Profiling

• SSIS: Data Profiling Task: Part 2 - Column Length Distribution

  In this blog entry I am going to outline the function of the Column Length Distribution profile request in the new Data Profiling Task in SQL Server 2008. BOL states about this profile request: Reports all the distinct lengths of string values in the Read More... Posted 02 March 2008 20:18 by jamie.thomson | 2 Comments Filed under: SQL Server Integration Services, SSIS, Microsoft, katmai, sqL server 2008, Data Profiling

• SSIS: Data Profiling Task: Part 1 - Introduction

  The February CTP of SQL Server 2008 delivered a usable version of the Data Profiling Task that is being introduced into SQL Server Integration Services 2008. I am putting together a series of blog entries that highlights the functionality available with Read More... Posted 02 March 2008 20:13 by jamie.thomson | 17 Comments Filed under: SQL Server Integration Services, SSIS, Microsoft, katmai, sqL server 2008, Data Profiling