Bulk Changes With XML Templates in Biml
Use template Biml objects and a high tier merge file to push template columns and template events onto every other table or package in BimlExpress.
6 docs tagged with "transformer"
View all tagsCreate an Expandable Transformer
How to create expandable transformers in BimlStudio
Metadata-Driven Data Flow Transformations With Biml
Generate Derived Column and Lookup transformations inside an SSIS data flow from rows in a transformation metadata model.
Roundtrips Between BimlStudio and Visual Studio
Learn how to 'roundtrip' your SSIS packages between SSDT and BimlStudio, and take advantage of the extended Biml toolsets.
Transformer Targeting Multiple SSIS Versions
Demonstrates a Package-level transformer that injects an 'OnPreExecute' logging pattern and branches its Biml emit on 'CompilerSettings["SsisVersion"]', so the same framework template produces SSIS-2008 R2 log providers or SSIS-2012 system-variable bindings depending on the target.
Transformer to Add Default Audit Columns to Every Table
A LocalMerge Table transformer that injects a standard set of audit columns (such as RowEffectiveDate, RowExpirationDate, and RowIsCurrent) onto every target Table without modifying the original Biml definitions.