CRM Integration using SSIS

If you read my blog then you would know that the two things I tend to work with the most are SSIS & CRM. I will often use SSIS to integrate data between the two - but it is not something you will often see documented and there are very few examples of how to do this available.

Today I came across this fantastic artcle that gives a great breakdown on HOW to do this:
http://blogs.msdn.com/crm/archive/2008/05/07/integrating-crm-using-sql-integration-services-ssis.aspx

Keep in mind that if you tend to work with clients that have Small Business Server that the Workgroup edition of SQL 2005 that ships with it/included in the R2 update has limited Integration services functionality so unfortunately, the suggestions in this article wont apply.