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

Question

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

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

There are several advantages that SSIS offers, making it a good choice as a migration / ETL platform (among other things, it must be fully customizable and can run in an automatic schedule).

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

Edit: I also looked at http://www.sqlis.com/ , although I did not find 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 may need to look through several guides to get the knowledge to create a solution for your specific scenario.

Another great source of SSIS advice is Jamie Thomson's blog. Man is a bit of a wizard with SSIS:

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

After you have looked through the material, if you need specific help, feel free to shed the line.

Answer 2

Here are some good ETL articles / tutorials from Microsoft:

• http://technet.microsoft.com/en-us/library/ms169917.aspx
• http://msdn.microsoft.com/en-us/library/cc671624.aspx

Answer 3

Check out Sql Server Central and Sql Server World Users' Group ( SSWUG ). If you can’t find the examples / tutorials / experts that you need in these two places, give up coding and do cooking because these sites are treasures!