Freigeben über


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

This is a great project for those of us who need to work with lots of ETL operations. Do check it out.

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.

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

Click to open the page

Comments

  • Anonymous
    August 13, 2008
    Sounds good. But, tell me the pros/cons of this new born baby. What are the features? How stable is it on 64bit environments? What type tasks should I create using this tool? As a first step I am thinking a basic dataflow task. -Run a spc from DatabaseA. -Truncate TableB at DatabaseB. -Push data to TableB. -Log errors if any, log number of records moved. -Rebuild indexes. Can the tool do this? Can I run dynamically created packages in sequential and in parallel? Good job folks... :) Thanks, Cem

  • Anonymous
    August 14, 2008
    Hi, Cem I'd prefer you place your comment on the CodePlex page, as I'm not the one maintaining the tool and hence, I cannot give you an expert's opinion on it.