Originally an internal MSIT solution that has been released as an open source project, the Microsoft SQL Server Metadata-Driven ETL Management Studio (a.k.a. MDDE) provides a tool for rapidly generating SQL Server Integration Services (SSIS) packages from a shared central metadatNote: The pre-release source code has been checked into TFS, and is under active development toward a v1.0, community-ready state.Prerequisites
Note: The code is currently compiled only against SQL Server 2005. SQL Server 2008 packages have not yet been tested thoroughly with MDDE.
Note: Additional documentation to follow.Got questions? Want to contribute?
- Either the MSI installer from an MDDE release installed or the solution code already built in Visual Studio 2005 to run in debug mode.
- An instance of Microsoft SQL Server 2005 database engine to install the repository to (may be local or remote).
- Microsoft SQL Server 2005 Integration Services must be installed on the target workstation.
- Microsoft BIDS is required for creating and maintaining package templates as well as debugging them.
Check out the SQL Server Community & Samples Discussion Forum