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

  •        41

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 metadat

http://sqlservermddestudio.codeplex.com/

Tags
Implementation
License
Platform

   




Related Projects

SSIS Event Log Business Intelligence


The SSIS Event Log Business Intelligence package is a complete BI project focused around SSIS Event Log data. Components include: - 9 SSRS Reports - ETL Data Mart - SSIS packages to load ETL Data Mart - Analysis Services Cube - PerformancePoint Dashboard

GDAL SSIS


GDAL SSIS is a collection of geospatial components for SQL Server Integration Services (SSIS) that leverages GDAL to support a large number of GIS data formats.

SSIS Dimension Merge SCD Component


A custom Data Flow component for SQL Server Integration Services (SSIS) that replaces the standard SCD Wizard with a superior experience, from the configuration UI to runtime performance. Performs 100x faster than the standard component, and edits are non-destructive.

SQL Server Integration Services (SSIS) Application Server


SQL Server Integration Services (SSIS) Application Server is an application server built around managed Microsoft SqlServer.Runtime API designed to extend standard Integration services management and execution model.

ETL Framework


This ETL Framework supports dynamic configurations and centralized logging for SSIS solutions in support of minimizing ETL TCO. It consists of an ETL Framework database, SSRS reports and template SSIS packages.



SSIS Package Manager - PacMan


PacMan - The SQL Server Integration Services Package Manager is a utility designed to permit batch operations on arbitrary sets of SSIS packages. Users can select a single package, a Visual Studio project or solution or a file system folder tree and then validate or update all...

SSIS Community Tasks and Components


This is a community project for developing additional tasks and components for SSIS, and identifying other CodePlex projects that do the same. 51 Integration Services extensibility projects exist on CodePlex - find them and over a hundred more from around the 'net right here.

Enterprise SSIS Framework


The Enterprise SSIS Framework is a project intended to simplify the management of an organization’s administration and ETL assets by abstracting the coordination and control flow into metadata. This project consists of the four parts: - Core SSIS Packages: A set of packages...

SQL Server Integration Services And Microsoft Dynamic CRM


One of the common tasks on any CRM system is loading and exporting data. SQL Server Integration Services (SSIS) is a great tool that helps you extract transform and load data. SSIS dose not provide a connector for Microsoft Dynamics CRM (MSCRM). It comes with connectors to the...

SSIS mojomo ETL-Framework


A modern SSIS ETL-Framework for executing and managing complex etl-processes. Bundled design patterns enable to speed up implementation of new requirements.

Microsoft SQL Server Community Samples: Integration Services


Samples for use with SQL Server Integration Services samples created by the Integration Services product team.

TaskUnZip for SSIS


Simple Task for SSIS (SQL Server Integration Services) for manage compress file ZIP. This task (Control Flow Items), permit compress/decompress file zip in SSIS Task context. Support password. _Work in Progress!_ ;-) Tnx to: *[url:http://sharpdevelop.net/OpenSource/SharpZi...

SSIS Expression Editor & Tester


An expression editing and testing tool for SQL Server Integration Services (SSIS). It also offers a reusable editor control for custom tasks or other utilities.

SSIS Custom Task BewiseSmartIndexManager


This project show an Maintenance Task which is availaible in Control Flow into SSIS Package.

Static Analyzer For Integration Services Packages


The parser check Best practice guidelines in Business Intelligence projects. Packages can be studied which are created with Visual Studio 2010.

FluentETL - Data automation made easy for coders


Automate data transfers with a few lines of code. Replace SSIS with concise yet powerful .NET code. Much simpler and easier to learn than Rhino ETL, yet flexible enough to use just about any data source.

Dynamic Data System - ETL for SQL Server using dynamic SSIS


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. Pr...

Error Output's Description


This custom component for SSIS (SQL Server Integration Services 2005 and 2008) helps you to enhance your error flows. It provides error description, column name and other useful information. You can connect many inputs to this component to create effective error flows quickly.