Recommendations for good SQL Server Integration Services (SSIS) examples/samples for ETL?

Question

Hi Everyone,

I'm looking for some decent examples/samples using SSIS to do some ETL from one SQL Server database to another not necessarily within the same instance.

The idea is to migrate rows of data with their heirarchies (relationships) from one OLTP database to another.

There are some advantages SSIS offers us which makes it a good choice as the migration/ETL platform (amongst other things it needs to be fully configurable and able to be executed on an automated schedule).

Does anyone know of any decent samples/examples besides the MS community samples (on Codeplex)?

Edit: I've also had a look at http://www.sqlis.com/ though I haven't found exactly what I'm looking for..

Answer 1

There are Microsoft Tutiorials on how to use each Task Component and concept available here: http://msdn.microsoft.com/en-us/library/ms141767.aspx

You will likely need to review several tutorials in order to aquire the knowledge to create a solution for your specific scenario.

Another excellent source of SSIS tips is Jamie Thomson's Blog. The man is a bit of wizard with SSIS:

http://blogs.conchango.com/jamiethomson/

Once you have had a look over the material, if you require specific assistance then feel free to drop a line.