Dynamic Data System - ETL for SQL Server using dynamic SSIS

DDS.zip

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.