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: | Category: derived column
Rating: |  Discuss |   Briefcase | 664 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,453 reads
   Items 1 to 2 of 2   
address parsing (1)    
data profiling (1)    
integration services (ssis) (1)    
metadata driven (1)    
pattern profiling (1)    
regular expressions (1)    
script component (1)