Create an ETL with SQL Server 2008 R2 Express

Question

I've recently installed the latest version of SQL Server (2008 R2 x64) and I'm now trying get my first steps to create an ETL.

Is it possible to create an ETL with SQL Server 2008 R2 Express, and if not is there some tool that provides that for free?

What I plan to do is collect data from multiple sources like a web services, rss feeds, a parsed url request, a file or maybe other database engine. Transform this collected data for an understandable schema (for my purposes) and store this in my SQL Server database.

Answer 1

If you are looking for a rather simple, yet very flexible and more code-based approach as an alternative to the SSIS (Integration Services), I'd recommend you have a good look at the Rhino ETL code library by Ayende Rahien.

Check out these resources:

• Rhino ETL 2.0
• Object-oriented ETL using Rhino ETL
• Write ETL jobs in pure C#

Rhino ETL is a code-based, programmer-oriented approach - it gives you nice, usable base classes, from which you can inherit and do just about anything - with very little effort.