Just a quick note, today I have to deal with a scenario to produce a message from the WCF-SQL response port, route it to another send port to send out to downstream. Everything has to be done using pure messaging. I did having some problems including BizTalk complaining ‘internal error’ while I tried to change the message type of the newly created message based on the query result. I then copied the context from the SQL response to the output message, everything seems working. I used the ‘RouteDirectToTP’ and ‘SPName’ for filtering on the another send port.

This is essentially a send port subscribing to another send port, interesting this even works…