Microsoft SQL Server Metadata-Driven ETL Management Studio (MDDE)

Project Description
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 metadata repository. MDDE is a software factory for SSIS packages that leverages the SSIS API to provide a templating engine that accelerates ETL development.

Note: The pre-release source code has been checked into TFS, and is under active development toward a v1.0, community-ready state.

Prerequisites

1. Either the MSI installer from an MDDE release installed or the solution code already built in Visual Studio 2005 to run in debug mode.
2. An instance of Microsoft SQL Server 2005 database engine to install the repository to (may be local or remote).
3. Microsoft SQL Server 2005 Integration Services must be installed on the target workstation.
4. Microsoft BIDS is required for creating and maintaining package templates as well as debugging them.

Note: The code is currently compiled only against SQL Server 2005. SQL Server 2008 packages have not yet been tested thoroughly with MDDE.

Usage
After installing MDDE using the MSI:

• Create the MDDE database using the "Microsoft SQL Server MDDE Studio Schema.sql" script that is installed along with the other program files. Warning: This script must be executed using SQLCMD mode.

• Double-click the desktop shortcut or use the shortcut in All Programs|Microsoft SQL Server MDDE Studio|SQL Server MDDE Management Studio to launch MDDE.
• Use the connect button in the toolbar to connect to the server\instance where you created the MDDE repository.

• Import a template from either a sample package or one that you've created to get started by right-clicking on the Templates node in the tree view.

Note: Additional documentation to follow.

Templates
TBD

Samples
TBD

Roadmap
TBD