Archive | SSIS RSS feed for this archive

SSIS – Package Configurations

by on March 25, 2010 in Configuration, Data Warehouse, SQL Server 2008, SSIS

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

5 Comments • Continue Reading →

SSIS Checksum – a must have skill

by on March 19, 2010 in Data Warehouse, SQL Server 2008, SSIS

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 →