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.
Tired of Waiting FOREVER to earn a profit online?
NEW Web-App Allows You To Legally Hijack Traffic And Authority From Wikipedia AND YouTube To Earn Affiliate Commissions In 24 Hours Or Less – in ANY Niche!
No Previous Skills Or Experience Required. You can literally be a COMPLETE Newbie and Get RESULTS with just 5 minutes of actual “work”..
IF YOU ARE INTERESTED, CONTACT US HERE==> email@example.com
I trust that this message finds you well. I have tried to contact you via email but it has bounced twice now so I am giving your contact form a go.
I enjoy blogging in my spare time and I have written a couple of articles for your blog markvsql.com.
Please find them attached on my Google drive: https://drive.google.com/drive/folders/1MiS9biGHhdq_O1u4qGTn54KWYfIsgD7u?usp=sharing
Do let me know what you think and do send me the links to the articles once you have managed to publish them.
Also, do let me know if you would like me to write some more articles for your blog.