DDS makes loading a data warehouse much easier and faster. This system uses SSIS to load standard and partitioned tables via SSIS packages created on the fly using metadata. No longer will you have to maintain complex SSIS packages. Only basic T-SQL skills are needed.

Prerequisites
Microsoft SQL Server 2008 Enterprise Edition (or higher). Integration Services must be installed on the SQL Server. Microsoft BIDS is optional for viewing packages.

Read the documentation in its entirety before you load this code.

Last edited Jan 27, 2012 at 6:03 PM by Bluefinjim, version 2