CODEWITHSUNDEEP
biztalk-2016
jesse crosswhite
jesse crosswhite

Reputation: 1

How to send the receive port name to a SQL procedure using WCF custom send port

I want to send the receive port name to a SQL procedure. I am using the message body shown here, but I get an event log error

The start element with name "BTS.ReceivePortID" and namespace "http://schemas.microsoft.com/BizTalk/2003/system-properties" was unexpected"

I'm trying this as the message body. I want the receive port name to be passed to the SQL stored procedure. It will pass the body correctly if I remove the source section.

<CustEDI_MiscDoc_save_to_queue_prc xmlns="http://schemas.microsoft.com/Sql/2008/05/Procedures/dbo">
    <xmlData>
        <bts-msg-body xmlns="http://www.microsoft.com/schemas/bts2007" encoding="string"/>
    </xmlData>
    <source>
        <BTS.ReceivePortID  xmlns="http://schemas.microsoft.com/BizTalk/2003/system-properties" encoding="string"/>
    </source>
</CustEDI_MiscDoc_save_to_queue_prc>

If I remove the <Source> section, the send port will work and send the body of the message to the SQL stored procedure. Adding the <Source> element that should send the Receive port ID causes an error.

Upvotes: 0

Views: 10

Answers (0)

Related Questions