Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 737
  • Last Modified:

Send mail task SSIS - Urgent help

I need to pick up 4 files saved within a specific location daily via an SSIS package.
I need to email these 4 reports together to one recipient based on the name & Date within the File name.
Basically the files are name e.g. SITE_Spend_22102008.csv for example and have the current date at the end of the file name in that format. I need to create a task to email these reports daily selecting the correct files from my location based on their naming convention and date.
I can't seem to figure out how to do this. Can I use the send mail task in SSIS and add multiple attachments, and how can I specify the date in the naming convention.

Please help this is Urgent and I need done before today....?
0
EHardie
Asked:
EHardie
  • 2
1 Solution
 
HoggZillaCommented:
I realize this question is somewhat duplicated, but here is a reference for looping through the files in a folder, reading and processing each filename. Might be useful for your task.
Good luck.
http://www.sqlis.com/55.aspx
 
0
 
HoggZillaCommented:
Don't believe the help comment at the bottom of the Send Mail Task Editor. The files should be separated by pips (|), not semicolons.
sendmail.bmp
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now