Solved

Send mail task SSIS - Urgent help

Posted on 2008-10-22
2
728 Views
Last Modified: 2013-11-10
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
Comment
Question by:EHardie
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 17

Expert Comment

by:HoggZilla
ID: 22781505
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
 
LVL 17

Accepted Solution

by:
HoggZilla earned 500 total points
ID: 22781548
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question