In Message Broker can you configure to use one queue but based on criteria send to a different Databases or is it a one to one relationship? I am tryibg to figure out if I should use Message broker or SSIS package.
Tell me more
×
Database Administrators Stack Exchange is a question and answer site for
database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
|
|
migrated from stackoverflow.com Jan 19 '12 at 10:15
|
Service Broker conversations are between services, not between queues. You send from a service, to a service. A conversation is tied to exactly a pair of services and cannot change. The same service can participate in any number conversations, with any number of peer services. If you want to send messages to multiple peers, you need to start multiple conversations. |
|||
|
|
|
The Service Broker simply acts as a messaging queue for the different Database Mail Profiles you have configured on the server. If you plan to reuse a mail configuration, then Database Mail is the way to go. Otherwise, the Send Mail task in SSIS will provide a more customized benefit. |
|||
|
|
