SSIS Send Mail Task To Multiple Recipients

Question

I'm using an SSIS "Send Mail Task" in an attempt to send to multiple recipients. In the TO line of the editor, I have specified the value as follows:

[e-mail];[e-mail].

Only the last email address in the semicolon seperated list receives the mail.

SMTP Server is Microsoft Exchange

I'm running SSIS 2008

I have confirmed that all individual address work when set as the sole value in the task editor settings.

The MSDN documentation states that multiple addresses in TO line is supported but I have not been able to get it to work as intended. Can someone help with what I am missing or is this a bug.

Thanks

Answer 1

Hello,

It should be working fine, do you have "." DOT at the end of second email. If yes then remove that , You don't need Dot at the end.

Thanks

 

---

http://sqlage.blogspot.com/

Answer 2

Aamir - There is not dot, its only: [e-mail];[e-mail]

I've tested this with multiple recipient email accounts and the result is always the same in wchich the Email Task is only sending to the last email address in the ";" seperate list. Are the special settings on the SMTP server or on the task properties that are require for this to work?

Thanks

Answer 3

Hello,

I had been using Send mail task in SSIS 2005 and SSIS 2008, Never encounter this issue.

 

Are you using some variable in TOLINE (Expressions), might be email address get over write with only one value. 

Please hard code the Two Email Address in TO and try again.

 

Are you able to CC to multiple Address or It behave the same way like TO?

What is the length or your two address? how many characters?

Please share your findings

Thanks

---

http://sqlage.blogspot.com/

Answer 4

I am running into a similar issue.  I have defined a String package variable, EmailTo.  The default value set in the package contains two email addresses, separated by a semicolon.  When executed from Visual Studio, it runs without error.  When I run the package from a command line, and pass the argument, /SET \PACKAGE.VARIABLES[User::EmailTo].PROPERTIES[Value];"[e-mail]", it still works fine.  However, as soon as I try to set the value to multiple recipients, each separated by a semicolon, similar to the value that I hard-coded in the package, I get the following error:

Warning: 2011-09-20 10:45:01.91

Code: 0x800291C7

Source: Send Mail Task Send Mail Task

Description: The address in the "To" line is malformed. It is either missing the "@" symbol or is not valid.

End Warning

Progress: 2011-09-20 10:45:01.91

Source: Send Mail Task

The SendMail task is initiated.: 0% complete

End Progress

Error: 2011-09-20 10:45:01.93

Code: 0xC002F304

Source: Send Mail Task Send Mail Task

Description: An error occurred with the following error message: "The specified string is not in the form required for an e-mail address.".

End Error

 

Answer 5

Try one with comma instead of semicolon, I am not sure which one works, did it some time back....

---

My Blog    |      Ask Me     

Answer 6

I tried replacing the semicolon with a comma.  Received the same error.  I still don't understand why the value passed in as a parameter behaves differently than the value entered in the variable definition in the package.  I've been using command line parameters for several years with no problems for numbers, dates, guids, etc.

Answer 7

The correct syntax when using semi-colons (;) in set variable of DTExec (as far as I remember) is to surround the value in "" like

/SET \PACKAGE.VARIABLES[User::EmailTo].PROPERTIES[Value];""[e-mail]; [e-mail]"" or

/SET "\PACKAGE.VARIABLES[User::EmailTo].PROPERTIES[Value]";"""[e-mail]; [e-mail]""" (yes, triple quote)

Think is the ; after the [value] confuses DTExec

---

Arthur My Blog

Answer 8

I'm having the same problem too, I never tried it before as I was sending to a group e-mail, but happened to need it and YES it's not working!! the semicolon or the double-quotes wrapping the whole string!  tried even multiple variations!!

Answer 9

I had this problem also, I am using SQL 2008 R2 This only occured when there is a space after the (;) semi-colon and before the next email. e.g. [e-mail]; [e-mail] if you remove the space so that it is one complete string it should work. e.g. [e-mail];[e-mail] Hope this helps.

Answer 10

JPurkins,

I have almost similar situation, I understand and works what you mentioned on Jan20, 2012 but in my case multiple addresses are assigned to 1 group email address.

As soon I use group email address, "Send Mail Task" doesn't send an email. I have too many addresses so I don't want to have hard corded values and it also gives us ability for not to change package if one or more address gets disable to need to add one or more.

Thanks.

Answer 11

Hello,

The issue was the "group email id" which was provided by IT was kind of not right but right. I looked into this email addresses list in outlook/exchange address book for this group email id. There are tons of emails listed in "E-mail Addresses" tab. Somehow all the addresses should work but I tried the email with domain name preceded to "group email id" and it worked.

BTW, I did not have to list/specify the email addresses with ; or , because the email id itself is a group email id on exchange server and it's server level group email id which has many members.

Thank You and apologize for late notification but hope this helps. In short, the answer was in Outlook/Exchange and not in SSIS control(s).

Answer 12

Thanks!  I had to revisit this problem, and the second option with the triple quotes works.  Talk about bizarre!

Answer 13

Can you mark the appropriate reply as the answer please?

---

Arthur My Blog

Answer 14

Can you mark the appropriate reply as the answer please?

----------------------------------------------------------------------

LoL

Answer 15

I had this problem also, I am using SQL 2008 R2 This only occured when there is a space after the (;) semi-colon and before the next email. e.g. [e-mail]; [e-mail] if you remove the space so that it is one complete string it should work. e.g. [e-mail];[e-mail] Hope this helps.

Thank you. This was driving me nuts. A little white space can do that to a man I suppose.

Answer 16

JPurkins has the correct answer.  Make sure there are no spaces and only semicolons separating your email addresses.  Seems silly, but that is how SSIS wants it.

Answer 17

triple quotes works for me, thanks.

Answer 18

FYI, the fix for me was to remove all white space, but also had to remove the semi-colon at the end.  i.e.

[e-mail];[e-mail];[e-mail]

I got the same message as above (i.e. The address in the "To" line is malformed. It is either missing the "@" symbol or is not valid.) when that last semi-colon was there.