SSIS - Send Mail Task - Multiple attachments
Posted on 2008-10-22
I have created an SSIS package that created 4 .csv files and stores them within my required location.
The files exported have an expression that allocates today's date so that each file is saved and renamed on a daily basis.
My Expression to create the File name for the various files looks like this; ( This is part of the Flat File Connection String)
"\\\\Lonbilling\\Billing\\Fraud Alert\\CLI_Spend_" + (DT_WSTR,4)DATEPART("dd",GETDATE()) + (DT_WSTR,4)DATEPART("mm",GETDATE()) +
The Evaluated Value looks like this;
I have 4 files with slightly different names all within the same location I want to pick up and attach within an email based on the current date.
I want to use the Send mail task to email all 4 attachments within one email to my recipients within the same SSIS package.
Please can someone tell me how I can attach multiple files into the Send Mail task based on my expression ? There is a FileAttachment Expression available however I don't know the correct code to specify more than one file ?
Help would be appreciated ?