Month: June 2009

Incorrect Information in SSIS 2005 Send Mail Task Tooltip For Attachments Property

I was trying to dynamically send multiple attachments via the Send Mail Task in a package.

In the Send Mail Task Editor, when clicking on the Attachments property field, the tool tip tells you that the file names must be separated by semicolons:

“Specifies the files to include as attachments to the message. Separate the file names with semicolons.”

Alas, a semicolon did not work for me. It was not until I separated my file names with a | (pipe) that my package ran successfully and emailed the files.

So, use a | to separate files in the Attachments property of the Send Mail Task in SSIS 2005; not a semi-colon.