http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660Hey - I know I'm late to the party - but I just saw this. Activewarehouse has an ETL subproject that might be interesting to look at. http://activewarehouse.rubyforge.org/etl/ http://ayende.com/2643/idea-the-boo-etl-dsl#comment6http://ayende.com/2643/idea-the-boo-etl-dsl#comment6Thu, 02 Aug 2007 00:07:09 GMTSounds interesting. Not sure if it's any help, but I have been using nAnt for ETL tasks in quite a few occasions. I have always ended up writing custom tasks though, which may take as long as an SSIS package to create, but the difference is it's easy to use with source control, easier to understand (in my opinon), easier to maintain (again my opinion) and easier to deploy and run. Maybe it's worth thinking of creating a set of re-usable nAnt tasks, the advantage is that you get a lot of nice features for free. I would be interested in contributing to such a project actually. http://ayende.com/2643/idea-the-boo-etl-dsl#comment5http://ayende.com/2643/idea-the-boo-etl-dsl#comment5Thu, 19 Jul 2007 14:30:41 GMTI second that - I wonder Ayende, have you looked at any of the upcoming IronRuby code? I'd like to see you take your boo concept and use Ruby instead. Just a thought ( http://www.plas.fit.qut.edu.au/Ruby.NET/ ) PS. any update on Exesto ? :) http://ayende.com/2643/idea-the-boo-etl-dsl#comment4http://ayende.com/2643/idea-the-boo-etl-dsl#comment4Thu, 19 Jul 2007 12:50:58 GMTThis sounds nice. Also, it's good to see Boo is living up to its vision of being an extremely extensible and easy language for whatever it is you want to do with it. http://ayende.com/2643/idea-the-boo-etl-dsl#comment3http://ayende.com/2643/idea-the-boo-etl-dsl#comment3Thu, 19 Jul 2007 09:37:11 GMTHi Ayende, Go for it ! I have a need for such a tool right now and was looking at SSIS (and not impressed at all). Take a week if you want to build the core, If not I think I will have to code such a tool but I'm not as fast as you are for sure. Cheers, R. LOPES http://ayende.com/2643/idea-the-boo-etl-dsl#comment2http://ayende.com/2643/idea-the-boo-etl-dsl#comment2Thu, 19 Jul 2007 03:37:02 GMTInteresting. Recently at our shop we've been talking about building a domain model for ETL. What really bothers me about "Reports" and "Data Warehouse" and all "DB Stuff" in general is that you have to drop your Practices like test-first, good OO principles, etc. http://ayende.com/2643/idea-the-boo-etl-dsl#comment1http://ayende.com/2643/idea-the-boo-etl-dsl#comment1Thu, 19 Jul 2007 02:07:02 GMT