http://blogs.charteris.com/blogs/valerym/default.aspx<i>Flat files and FTP ought to be enough for anybody...</i>enCommunityServer 2007 SP2 (Build: 20611.960)http://blogs.charteris.com/blogs/valerym/archive/2006/11/08/Why-I-Don_2700_t-Like-The-SQL-Adapter_2E002E002E00_.aspx#137Sun, 19 Nov 2006 23:51:29 GMT0cdfd867-77e4-483c-9e74-84c93cc8eba0:137valerym<p>Thanks for your comment, Matt. I will definitely have a look at this implementation. Did you ever have to use this adapter when integrating large volumes of SQL data?</p> <img src="http://blogs.charteris.com/aggbug.aspx?PostID=137" width="1" height="1">http://blogs.charteris.com/blogs/valerym/archive/2006/11/08/Why-I-Don_2700_t-Like-The-SQL-Adapter_2E002E002E00_.aspx#135Wed, 15 Nov 2006 14:36:47 GMT0cdfd867-77e4-483c-9e74-84c93cc8eba0:135Matt<p>If you have not already done so, you should look at this DB adapter.</p> <p><a rel="nofollow" target="_new" href="http://www.topxml.com/biztalkutilities/biztalk2006DB.asp">http://www.topxml.com/biztalkutilities/biztalk2006DB.asp</a></p> <p>It covers off most of the points you have mentioned about the Sql Adapter and works with many different databases. I originally was using it with Oracle databases but have also used it against a Sql Server 2000 database for a batch operation (ie needed to do an update, insert, call a stored procedure within a single db transaction). Only problem is the adapter is not free, but the price is reasonable.</p> <img src="http://blogs.charteris.com/aggbug.aspx?PostID=135" width="1" height="1">