SSIS package configurations allow for portability of packages, password management, and security.
Archive | Data Warehouse RSS feed for this archive
SSIS Checksum – a must have skill
Overview When loading from source systems that don’t yet have the SQL Server 2008 Change Data Capture (CDC) enabled, using a checksum calculation to determine if data has changed is a critical Data Warehouse load concept to understand. This will allow you to read the source, that can have dozens of columns, and with a […]
Data Quality -Dynamic Business Validation
Table driven, dynamic validations to find post-load data issues.
Database Driven Aggregations
Introduction Have you ever had a series of aggregate (tsql) queries to run? Do you want to be sure they all run in the right order? Do you want to make the changes “dynamic” (no code changes required)? Certainly you can build an SSIS package that calls sql with the control-flow and control dependencies, however, […]
StefBauer's Blog - @StefBauer 