SSIS Derived column task string operations does not have a LEFT() function.
Use this in a Derived Column task in an SSIS Data Flow component, where one needs to get only the LEFT most characters in a string.
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.
2010-02-23
3,291 reads