Send Mail Task through SSIS Package

Question

3.00/5 (1 vote)

See more:

Hi,

I want to create SSIS package of Send Mail Task.
This task already has a File System Task which generates an excel sheet everyday based on current date.
And this task also already has a Data Flow Task which transfers data from database to exel sheet.

The problem is all the generated excel sheets are in a particular folder and the latest excel sheet needs to be sent to a a group of people as an attachmnt.How to do that?
When i go to Properties of Send Mail Task there is an option of Attachments but how to make it a dynamic one?

These tasks needs to be run through SQL Server Agent Jobs.

Only attachment part is left.The rest has been completed

Posted 7-Oct-13 0:55am

Member 10256908

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

coded007 · Answer 1 · 2013-10-07T20:25:00

you can use the send mail task and pass the file name dynamically through expression to task and schedule it as per your requirments.

For example, if you want to attach files, "d:\Data_20070119.xls", use this expression in SendMail Task

FileAttachMent

C#

"D:\\" + "Data_" + REPLACE(SUBSTRING((DT_WSTR, 50) GETDATE(), 1, 10), "-","") + ".xls"

you should use "\\" instead of "\"..

Send Mail Task through SSIS Package

1 solution

Solution 1

Add your solution here

Preview 0

Send Mail Task through SSIS Package

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us