Send mail using SSIS package

Posted by Nkkppp under Sql Server on 9/25/2012 | Points: 10 | Views : 2146 | Status : [Member] | Replies : 4
Hi,

I have a table with the columns

Username,EmailId,JoiningDate,Address.

So using this data i would like to schedule a job which runs once in a week(eg:sunday) and the mail has to be sent to the users to join the organisation whose joining date is between particular dates.

Can anyone please provide a complete description with screenshots if possible as I am new to SSIS.

Thank you.

Regards,
Prathap




Responses

Posted by: Nkkppp on: 9/25/2012 [Member] Starter | Points: 25

Up
0
Down
Also explain is there any advantage of using SSIS instead of C# code in Windows Scheduler
(i.e. placing the dll)

Nkkppp, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: T.Saravanan on: 9/25/2012 [Member] [MVP] Silver | Points: 25

Up
0
Down
Hi,

By using "Send Mail Task" is possible. Refer the below link...
http://www.mssqltips.com/sqlservertip/1731/sending-email-from-sql-server-integration-services-ssis/

Note:
If you want to set the From and To address dynamically, use Expressions for set those values (or) declare variables and set the values from config/ database to this variables.

Thanks,
T.Saravanan

Nkkppp, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Nkkppp on: 9/25/2012 [Member] Starter | Points: 25

Up
0
Down
Thank you Saravanan.

Can you also Also explain if there is any advantage of using SSIS instead of C# code in Windows Scheduler

Nkkppp, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Hariinakoti on: 9/25/2012 [Member] Starter | Points: 25

Up
0
Down
Nice exolanation Saravanan

Thanks & Regards
Hari

Nkkppp, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response