BizTalk SQL to XRef Send/Receive Ports to Orchestrations
Suppose you are at a new clients, and you want to see quickly all the orchestrations are bound to send and receive ports. Here’s some code to help you get started with that. <pre> select op.nvcName as 'OrchInternalPortName', o.nvcName as 'OrchName', 'SendPort' as 'SendOrReceive', sp.nvcName as 'PortName' from bts_orchestration_port op inner join […]