Why am I receiving this empty xmlns? SQL Stored Proc > BizTalk

Kyle Mann 1 Reputation point
2025-04-24T16:56:36.6133333+00:00

I'm hoping someone can help, I'm switching over a BizTalk port from adapter 'SQL' to 'WCF-SQL' due to the former being removed from the next version of BizTalk, I can receive the message from the Stored Proc fine except for there being an xmlns tag in the child record which is causing the map on my receive port to fail, I've ran the stored proc from SQL studio and it is not present so I'm wondering if WCF-SQL is somehow adding it in, anyone got an idea? When the old port running under 'SQL' is enabled this xmlns tag does not exist.

enter image description here

Many thanks, Kyle

Microsoft BizTalk Server
Microsoft BizTalk Server
A family of Microsoft server products that support large-scale implementation management of enterprise application integration processes.
387 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.