Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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,345 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 | 1,791 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,020 reads
   Items 1 to 3 of 3   
 
Tags
address parsing (1)    
derived column (1)    
ftp task (1)    
metadata driven (1)    
pattern profiling (1)    
regular expressions (1)    
script component (1)    
sql server 2008 (1)    
video (1)