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
Azure Solutions Architect writing about Azure Data & Analytics and Power BI
Since my last blog post about a SSIS package design pattern I’ve received quite some positive reactions and feedback. Microsoft
I recently had a chat with some BI developers about the design patterns they’re using in SSIS when building an
Recently I had to create a fact table with a lower grain than the source database. My source database contained
Replace the multiple “Lookup Error Output” Derived Columns and Union All’s with a single Derived Column and get a performance