Microsoft says that SQL Server Integration Services (SSIS) “is a platform for building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.” A simpler way to think of SSIS is that it’s the solution for automating SQL Server. SSIS provides a way to build packages made up of tasks that can move data around from place to place and alter it on the way. There are visual designers (hosted within Business Intelligence Development Studio) to help you build these packages as well as an API for programming SSIS objects from other applications.








I have done the integration successfully ….if u want to try follow this link

http://community.dynamics.com/product/crm/crmtechnical/b/sonomapartners/archive/2009/12/27/data-integration-47-migration-using-sql-integration-services-40-ssis-41-2008.aspx

http://blogs.msdn.com/b/crm/archive/2008/05/07/integrating-crm-using-sql-integration-services-ssis.aspx