Biztalk 2006 SQL Server Adapter

Home Page Forums BizTalk 2004 – BizTalk 2010 Biztalk 2006 SQL Server Adapter

Viewing 1 reply thread
  • Author
    Posts
    • #15422

      Hello I am developing a BizTalk 2006 Application that needs to insert the contents of a message into a SQL Server table and then respond with some lookup info (via a stored procedure). There’s nothing special in terms of data types. I am having a lot of trouble with the SQL Server Adapter which is what I think I need to use not errors really I’m just missing how you effectively use it for this purpose. Can anyone point me in the direction of a good White Paper which explains what to do? I didn’t find the Walkthrough that ships with Biztalk very helpful. Thanks to anyone who can lend a hand.

    • #15423

      It can be a tricky adapter. Seems like you have a \”send\” adapter where the input is your data to input, and the \”response\” is the lookup data. This MSDN article (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/BTS_2004WP/html/74cfc9d0-0974-4f4a-81f5-6768ff245df1.asp?frame=true) is still one of the better ones for understanding the adapter.

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.