Solved

Send mail task SSIS - Urgent help

Posted on 2008-10-22
2
722 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
  • 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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

896 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now