SSIS with Dynamics CRM: Case study from a large bank

Two years ago, I wrote a short blog post here about using SQL Server Integration Services (SSIS) with Microsoft Dynamics CRM. There are 2 ways that you can work with CRM programmatically: The supported way, through the Web services API that the application exposes The, uh, less supported way, by interacting directly with the database where CRM stores its data And we've got some information for you today on both approaches! First, our feature article, "Uses for SSIS with MSCRM In a Bankin... [More]

Using Integration Services with Microsoft CRM

I counted 57 posts (not threads) in the SSIS forum on MSDN about using Integration Services with Microsoft CRM. Thanks to SSIS-with-CRM wiz Catherine Eibner from Australia, I discovered that CRM MVP Darren Liu has covered the subject in detail in a blog post from May. His post includes all the implementation details and lots of screen shots, and the comments indicate that others are interested too. http://blogs.msdn.com/crm/archive/2008/05/07/integrating-crm-using-sql-integration-services-ssis.a... [More]