The article that I wrote on integrating CRM using SQL Integration Services (SSIS) is posted on the CRM Team Blog. I hope this will help you in your next CRM integration project. You can click the link below to read the article. http://blogs.msdn.com/crm/archive/2008/05/07/integrating-crm-using-sql-integration-services-ssis.aspx
I would like to thank Darren Hubert, Matt Bonig, and Jeremy Hofmann on showed me the work around and helping me understand how to use SSIS to call web services. Thanks Guys!