Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ambulare
Starting Member
8 Posts |
 Posted - 2012-05-30 : 09:27:15
|
| Hi all,I have a series of reports that one of my colleagues e-mails out every day to Outlook distribution lists.I've replicated the reports on SSRS 2008 with the intention of automating the sending, however I've hit a snag.The distribution lists contain hundreds of people and I'm struggling to work out how to manage the e-mailing.I've tried populating a database table with the e-mail addresses and using a data driven subscription, but this fails after the first 10 or so and logs the error "The maximum number of concurrent connections has exceeded a limit, closing transmission channel"Can anyone suggest a way to manage such a large number of recipients? I'd like to avoid typing them all into the "To" field if possible - especially as I'm not sure if this would work either due to the length of the character string that would be needed to contain all those addresses.Is it possible to use some form of distribution list (like those found in Outlook) with SSRS so I can just send to "theDistroList@Mymail.com" and have the e-mail server deal with it? |
|
|
Ambulare
Starting Member
8 Posts |
Posted - 2012-05-30 : 11:12:59
|
| Alternatively, does anyone know if it's possible to use a data driven subscription to return a semicolon delimited string for the e-mail address fields, so you can send a single mailing to a whole bunch of people instead of processing each address in the source table as a different e-mail and therefore being rejected by the e-mail server due to the number of connections? |
 |
|
|
|
|
|
SSRS 2008 - Mailing a Large Number of People