Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Recurring SQL Error › Recurring SQL Error
There are a number of ways.
[list:c86f173b74]1. Add the map to the Receive Port as an inbound map. The receive port will publish an updategram message to the messagebox. You can use SQL send port with a filter to subscribe to this message.
2. Add the map to the Send Port. The receive port will publish a source message to the messagebox. You can use SQL send port with a filter to subscribe to this message where it will be mapped.
3. Use an orchestration with a construct message shape and a transform message shape. The orchestration will receive a source message and send an updategram[/list:u:c86f173b74]
The best bet with a SQL send port is to use an orchestration.