Thiago Almeida has written a nice article which details how to call a stored procedure multiple times without using a loop shape here: http://connectedthoughts.wordpress.com/2008/09/09/multiple-stored-procedure-calls-using-the-biztalk-sql-adapter-without-a-loop-shape/
Multiple Stored Procedure Calls using the BizTalk SQL Adapter without a loop shape
Posted: March 31, 2012 in BiztalkTags: Biztalk, SQL Adapter
0