- This topic has 3 replies, 1 voice, and was last updated 9 years, 1 month ago by
.
-
Posts
-
-
I have successfully created my first biztalk project which does: receive a flat file or xml file, send it to stored procedure to update data in a SQL server table.
Now I am trying to retrieve data from one sql server table and then use the returned data to update table in another sql server table. I found an article how to create and consume a BizTalk message through SQL server without using SQL Server adapter. But I want to learn how to create and consume a BizTalk message through SQL server using SQL Server adapter.
Could somebody suggest some links for me to learn?
Thank you.
-
Hi,
Have a look at the Query Notification capability in WCF SQL adapter to accomplish your goal:
http://seroter.wordpress.com/2009/01/12/query-notification-capability-in-wcf-sql-adapter/
Daniel.
-
Daniel,
Thanks for your reply. But the link didn’t help me.
After I add generated items using a stored procedure without parameter to retrieve data, according to article I read at http://www.codeproject.com/KB/biztalk/SP_XML_CLAUSE_BT.aspx , I need to change the schema location so that it will use the shema that is automatically generated by executing the stored procedure in SQL Server Management Studio.
My issue is: I cannot change the schema location. It seems to be read only.
The stored procedure is very simple like this:
ALTER
procedure [CMCustomer].
[p_biztalk_salesExpiraton_updateOR_RYGandADP]
as
SELECT
ConsistentNames.ConsistentName, custsummary.OR_RYG, w_ConsnameDaysToPay.
psixmonthavg
FROM
ConsistentNames RIGHT OUTER
JOIN
custsummary
ON ConsistentNames.ConsistentName = custsummary.ConsistentName RIGHT OUTER
JOIN
w_ConsnameDaysToPay
ON ConsistentNames.ConsistentName = w_ConsnameDaysToPay.
consistentname
FOR XML
AUTO
-
-
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.