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

Content with tags Integration Services (SSIS), Regular Expressions Rss

   Items 1 to 2 of 2   
 

Regular Expression Transformation

The regular expression transformation exposes the power of regular expression matching within the pipeline. One or more columns can be selected, and for each column an individual expression can be applied. The way multiple columns are handled can be set on the options page.  Read more...
By Additional Articles 2012/08/10 | Source: sqlis.com | Category: integration services (ssis)
Rating: (not yet rated)  Rate this |   Briefcase | 3,691 reads

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,495 reads
   Items 1 to 2 of 2   
 
Tags
address parsing (1)    
data profiling (1)    
derived column (1)    
metadata (1)    
pattern profiling (1)    
script component (1)