Re: WCF-SQL Adapter Bulk Inserts with Foreign Keys?

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › WCF-SQL Adapter Bulk Inserts with Foreign Keys? › Re: WCF-SQL Adapter Bulk Inserts with Foreign Keys?

September 14, 2009 at 4:01 PM #23244
community-content

    Option1.
    Change your Orders schema and the map that creates this message.
    In the schema remove the MyOrder node, so that  Orders is the root node. Also select the <schema> node and set the TragetNamespace property to blank. Unfortunately this will affect your map.

    Option 2,
    Change the XQuery in your stored procedure:

    WITH XMLNAMESPACES( ‘http://my namespace.load_schema’ AS  “ns0”)
    SELECT
       Table1.Column1.value(‘PONum[1]’, ‘CHAR(1)’)
      FROM
       @LoadXMLData.nodes(‘/ns0:MyOrder/Orders/Order’) AS Table1(Column1)