ETLGEN / USER GUIDE
Build SSIS expressions
Turn SQL-style transformation logic into expressions for Derived Column and Conditional Split components.
Open the builder
After your source tables and joins are defined, choose Tools → SSIS Expression Builder.
Choose a transformation
- Derived Column creates or changes a value.
- Conditional Split evaluates a Boolean condition and routes matching rows.
Generate and review
Enter a T-SQL expression or search condition and select Generate SSIS Expression. ETLGen adds casts that match SSIS data types, such as DT_WSTR for text. Test the generated expression with representative data before deploying the package.