Metadata-Driven ETL Platform by Extending SSIS

Question

Metadata-Driven ETL Platform by Extending SSIS

Kayal-717623

Ten Centuries

Points: 1390
More actions
May 6, 2008 at 8:47 am

#186110

Have you guys came across Metadata driven ETL management studio? This is really interesting to generate SSIS dynamically from metadata. I need to know more abt it and how to use it ? So if you know more about this, it would be really helpful. THe information i have is.
http://msdn.microsoft.com/en-us/library/cc313017(SQL.100).aspx
http://www.codeplex.com/SQLServerMDDEStudio
Thanks,
Kayal

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Frank Bazan SSCertifiable Points: 5378 More actions · Answer 1

It's a neat little tool, but the problem I've had with it is that you can't import templates that contain a script component or an Execute Process task... I didn't test it with any others, but that alone is a major bug considering the majority of my packages have a script component in for one task or another...

Kindest Regards,

Frank Bazan

Kayal-717623 Ten Centuries Points: 1390 More actions · Answer 2

Hi Frank,

Thanks for your reply. Appreciate it. After you import template in MDDE, how do you work on it to generate dynamic SSIS ? Please advice. What is the use of it? Like always do you have to import SSIS package and create SSIS from it. The document said that we can create SSIS from MDDE just by specifying the metadata. Looks like it doesnot work like that. Can u please tell us how it works.

Thanks again for your help,

Kayal

sabyasm SSCarpal Tunnel Points: 4324 More actions · Answer 3

[font="Comic Sans MS"]

This is strange. I am stuck here too - came across this codeplex project and very much interested to try this out.

After importing a simple package - I couldn't find a way to generate the dynamic package or worst - couldn't find a single documen which explains how to do this.

Did anyone tried this? Any information?

[/font]

[font="Comic Sans MS"]--
Sabya[/font]

naveenka SSC Enthusiast Points: 174 More actions · Answer 4

Check this link for some documentation

http://blogs.msdn.com/b/mattm/archive/2008/06/13/mdde-metadata-driven-etl.aspx

Also check this if you are using SQL 2008

EzAPI - Package Generation API (SQL 2008)

http://sqlsrvintegrationsrv.codeplex.com/releases/view/21238

Naveen Abraham