0

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.

0

2 Answers 2

2

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.

0

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.