Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Derived Column Rss

   Items 1 to 2 of 2   
 

LEFT equivalent in SSIS Derived Column Task

This command is the equivalent of the LEFT() function (cumbersome but effective)  Read more...
By Stewart Campbell 2011/11/29 | Source: SQLServerCentral.com | Category: derived column
Rating: |  Discuss |   Briefcase | 632 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,344 reads
   Items 1 to 2 of 2   
 
Tags
address parsing (1)    
data profiling (1)    
integration services (ssis) (1)    
metadata driven (1)    
pattern profiling (1)    
regular expression (1)    
script component (1)