Tag Archives: SSIS

SSIS – Load Audit

Audits in SSIS create reusable packages that are easy to maintain, and provide valuable information about the data they are affecting.

2 Comments Continue Reading →

SSIS Design Tip – Build For Restartability

SSIS package restartability is an important thing to think about as you think about design. It will allow for supporability, as well as ease and speed in new development.

Leave a Comment Continue Reading →

SSIS – Package Configurations

SSIS package configurations allow for portability of packages, password management, and security.

4 Comments Continue Reading →

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 […]

7 Comments Continue Reading →