Welcome to MSDN Blogs Sign in | Join | Help
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

Posted: Sunday, July 20, 2008 9:05 AM by hovsep

Comments

a-foton » Microsoft SQL Server Metadata-Driven ETL Management Studio (MDDE) - Home said:

PingBack from http://blog.a-foton.ru/2008/07/microsoft-sql-server-metadata-driven-etl-management-studio-mdde-home/

# July 20, 2008 4:38 AM

cem_demircioglu said:

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

# August 13, 2008 5:57 PM

hovsep said:

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.

# August 14, 2008 9:22 AM
Anonymous comments are disabled
Page view tracker