Re: Best way of inserting data into SQL Server through BizTalk

Hi,

 

    Here are a few blogs describing how to use WCF SQL adapter:

http://www.biztalkgurus.com/blogs/biztalksyn/archive/2009/03/02/using-the-wcf-sql-adapter-in-net-calling-stored-procedures.aspx

http://www.biztalkgurus.com/blogs/biztalksyn/archive/2009/03/04/using-the-wcf-sql-adapter-in-net-executing-sql-statements.aspx

http://connectedthoughts.wordpress.com/2009/06/29/using-the-biztalk-wcf-sql-adapter-to-load-a-flat-file-into-a-sql-server-2008-table/

 

   Also, if you have time, check out this webcast presentation of WCF SQL adapter:

http://www.cloudcasts.net/ViewWebcast.aspx?webcastid=2521554268962766719

 

    Daniel.