Archive | SSIS RSS feed for this archive

SSIS – Package Configurations

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

5 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 →