SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags Integration Services (SSIS), Data Profiling Rss

   Items 1 to 3 of 3   

Dynamically Map Column Data Based on Column Pattern Profiling

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.   Read more...
Rating: |  Discuss |   Briefcase | 2,509 reads

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

See how the data preparation tasks within SSIS can be used to retrieve data or to validate the quality of data.  Read more...
Rating:  Rate this |   Briefcase | 2,159 reads

Viewing the Data Profiling Task Data - SQL School Video

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.  Read more...
By Brian Knight 2009/01/27 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 5,095 reads
   Items 1 to 3 of 3   
address parsing (1)    
derived column (1)    
ftp task (1)    
metadata (1)    
pattern profiling (1)    
regular expressions (1)    
script component (1)    
sql server 2008 (1)    
video (1)