Take the 2-minute tour ×
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.

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.

share|improve this question

migrated from stackoverflow.com Jan 19 '12 at 10:15

This question came from our site for professional and enthusiast programmers.

2 Answers 2

up vote 2 down vote accepted

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.

share|improve this answer

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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