SQL->WCF-SQL receive port
Hi guys,
Before I upgrade my BizTalk server from 2016 -> 2020 I need to update a receive location that uses the SQL adapter to WCF-SQL, the receive location calls a SQL stored proc, I've gotten it to a point where it will receive the data however it does not include the xml declaration at the top causing the map on the port to not work properly, how can I add that xml declaration? Is it just a simple setting on the transport properties?
Also it polls the same message a few times which is not ideal, I imagine that this is because I have the 'PolledDataAvailableStatement' to 'Select 1' as a temporary value just to get the port working, what can I change this to so it only grabs one instance of the message? I've ran the stored procedure from SQL and it does only bring back one instance so I don't believe the SP to be the issue?
Many thanks,
Kyle