Curious are extracts from BizTalk as source to "some SQL Server" destination? Although not recommended, but seems to help is using (nolock) hint. Was not sure from message if BizTalk or T-SQL issue from destination SQL Server.
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀