Can anybody help with this problem please?I’m using “set value” in SQL agent to pass in an email address to my SSIS package, if I put in a value of: aaa@bbb.com It works fine, but if I attempt to input multiple email addresses it fails aaa@bbb.com;bbb@bbb.com It doesn’t appear to like the “;”. Any ideas anyone???BoroFC

Its probably because under the covers its calling dtexec and passing those values using the /SET option. If you look at the dtexec utility documentation you'll see that it describes the syntax of /SET as: /Set propertyPath;value As you can see it includes a semi-colon and hence I'm not surprised that a semi-colon in the value that you are trying to pass in causes a problem. As a workaround you could try wrapping your semi-colon delimited list in quotes: "aaa@bbb.com;bbb@bbb.com" I'm confident, but not 100% certain, that that will work! Let me know! -Jamie http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

Hi Jamie, many thanks for the response. If I look at my command line table when Email = aaa@bbb.com, it looks like: /SET "\package.Variables[EmailAddress].Value";"aaa@bbb.com" /REPORTING E If I change the value to “aaa@bbb.com;bbb@bbb.com”, it looks like: /SET "\package.Variables[EmailAddress].Value";"\""" aaa@bbb.com;"" bbb@bbb.com ""\"" /REPORTING E But the weird thing is, if I close the job properties window and re-open it again, I lose this line from my set values screen all together!!! Help ???BoroFC

Use comma instead.Hope this helps !! Sudeep Raj| My Blog

Urgh. That doesn't work too well does it? Looks like a bug! If I were you I would ditch the use of the SSIS jobstep and use the command-line job step instead. Here's why: SSIS and SQL Server Agent - Choosing the Right Job Step Type (the third bullet point is the clincher) -Jamiehttp://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

A comma doesnt work, it only sends to the 1st Email address in the list.BoroFC

Hello, I can confirm your findings: inside [Send Mail Task] or a variable used in this task in a SSIS package: aaa@aaa.aa; bbb@bbb.bb – works in SQL Job, SSIS Package type, [Set Values] tab: aaa@aaa.aa, bbb@bbb.bb - job completes ‘ok’, but email sent only to 1st address (aaa@aaa.aa) aaa@aaa.aa; bbb@bbb.bb - job fails " aaa@aaa.aa; bbb@bbb.bb” - job completes ok, email sent to both addresses seems resolved but works only until you open the job again and the variable disappears! (so you have to enter the variables each time you modify the step) I know 2 workarounds: to use [Operating system (CmdExec))] type instead of SSIS Package type to execute DTEXEC my applied workaround – to use this expression for email To/CC line properties: REPLACE( @[User::SummaryMailToLine], ",", ";" ) (replace , by ; in (passed from SQL job) email addresses) and to use values for email addresses with comma inside sql job: aaa@aaa.aa, bbb@bbb.bb rob

I've just discovered that neither can you set a value of an email address of the form :- jim.bloggs@blah.com In general there are a lot of difficulties using the 'Set Values' tab of SQL Agent, even under 2008 R2. In addition if you have two email addresses of the above form in the package TO address of an email task ( a period appears before the @ symbol), a erroneous warning regarding an invalid email is shown. When trying to set a semi colon delimited list of two or email addresses of the above form via DTEXEC they must be quoted as in /SET "\Package.Variables[User::emailTo].Value";"""jim.bloggs@somedomain.com; jane.bloggs@somedomain.com"""