Tag: SSIS

Finding the Column Name of an SSIS Error Output Error Column ID Many SSIS data flow components have error outputs for optionally directing rows through, e.g. for handling data type conversion errors. These error outputs include the data columns being handled by the component, as well as 2 additional columns – an ErrorCode column and an ErrorColumn […] “Finding the Column Name of an SSIS Error Output Error Column ID”

Updating Type 2 SCD Attributes using the T-SQL Merge Statement During Matt Masson’s SSIS Performance Design Patterns pre-con day at SQLBits last year, Matt discussed the use of the T-SQL Merge statement for implementing Type 2 SCD attribute updates. In one of his posts on Microsoft’s SSIS Team Blog, he references the source of this idea as being […] “Updating Type 2 SCD Attributes using the T-SQL Merge Statement”

Updating Type 6 Slowly Changing Dimension Attributes This post completes my mini-series on implementing the Kimball-based SSIS patterns described by John Welch in his SQLBits session on Handling Advanced Data Warehouse Scenarios in SSIS. The task here is how to best implement inserts and updates to slowly changing dimensions with Type 6 […] “Updating Type 6 Slowly Changing Dimension Attributes”