SSIS – Package design pattern for loading a data warehouse – Part 2
Since my last blog post about a SSIS package design pattern I’ve received quite some positive reactions and feedback. Microsoft
Tag: Design Pattern
SSIS – Package design pattern for loading a data warehouse
I recently had a chat with some BI developers about the design patterns they’re using in SSIS when building an
SSIS – Blowing-out the grain of your fact table
Recently I had to create a fact table with a lower grain than the source database. My source database contained
SSIS – Decrease your fact table loading time up to 40%
Replace the multiple “Lookup Error Output” Derived Columns and Union All’s with a single Derived Column and get a performance
Jorg Klein's Blog 