Urgent Help with SQL Adapter

Home Page Forums BizTalk 2004 – BizTalk 2010 Urgent Help with SQL Adapter

Viewing 1 reply thread
  • Author
    Posts
    • #17572

      hi everybody,

      i am using the SQL Adapter for the first time (actually for my first production BizTalk project)…

      now the problem is that i have a complete orchestration built and running…now i need to update it to use the SQL Adapter in order to update a temp table in SQL Server. What i need is a way to pass in an RqUID parameter (which is an element in my message) to a stored procedure that will update my temp table. Now please note that the temp table does not correspond to a particular schema inside my project…I only want to update it for future reporting reasons…

      how can i do the above, knowing that every article i read about SQL adapter required generating a schema adapter metadata and go from there. However as i said in my case i do not want to create any new metadata schemas. i simply want to retreive a RqUID parameter from a message, and then use it to update a reporting temp table.

      can this be done?

      thanks for your help…

    • #17597

      MSH,

      there's an example beginning on page 343 "Calling Stored Procedures Using the SQL Adapter" in the book BizTalk 2006 Recipes by Beckner, Goeltz, Gross et al.

      Hope this helps. 

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