April 15, 2009 at 12:53 am
Hi
I am planning to design Metadata driven ETL implementation using SQL SERVER 2008 SSIS.
I need some sample examples or related documents /site references to implement this.
Thanks for any ideas, suggestions, or thoughts on this.
Regards,
BJ
June 24, 2009 at 10:54 am
Hello BJ,
Not sure how far you have gone with this yet but I would be interested in learning about your experiences.
Here is a link in case you've not gotten too far:
http://blogs.msdn.com/mattm/archive/2008/06/13/mdde-metadata-driven-etl.aspx
There used to be a white paper on this subject but can't seem to locate a download for it.
Marc
Marc BeacomManaging Partner DatalereTAP the Power of Data(tm)
September 19, 2009 at 12:15 am
Marc,
Thanks for your reply.
I have already gone through MDDE.
MDDE is only supported by SQL SERVER 2005.
The following package elements are currently supported:
Containers
Sequence
For Each
For
Connection managers
Event handlers
Log providers
Variables
Execute SQL Task
Data Flow Task
Derived Column
Lookup
OLEDB Command
Row Count
Merge
Sources
Flat File
OLEDB
Destinations
Flat File
Raw File .
We can not change the mapping of the source and destination tables,if we want to do.
I am looking for Architecture of Metadata driven ETL,where I can stored mapping of tables into metadata repository(in the database).
Regards,
BJ
January 15, 2012 at 2:48 pm
BJ,
Did you ever find anything along this lines? I too am looking at seeing what I can leverage, and the MDDE project isn't suitable (since it hasn't been updated from SQL Server 2005.)
April 24, 2012 at 1:25 pm
I recently launched a metadata driven ETL tool that you may be interested in. http://www.leapfrogbi.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply