Friday, 28 March 2008

Send Mail Task Editor - Mulitple Attachments Problem

The SSIS Send Mail Task Editor provides the very confusing tip to use a Semicolon (;) to separate multiple attachments files as you can see in the below screenshot.




Using a semicolon Doesn't Work!

This seems to happen if you are using expressions to list muliple attachments or typing the list manually - so the inclusion of the semicolon causes the send mail taks to fail.

The MSDN article found here provides the hint you need to make it work: http://msdn2.microsoft.com/en-us/library/ms188441.aspx

i.e. Provide the file names of attachments to the e-mail message, delimited by the pipe () character.

0 comments: