Send mail using SSIS package

Write New Post |

Search Posts | Answered

Resolved Posts |

Un Answered Posts |

Forums Home | Today's Posts |

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

Reply | Reply with attachment | Alert Moderator

Replies

Nkkppp
Posted on: 9/25/2012 10:26:26 AM

Level: Starter | Status: [Member] | Points: 25

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. | Reply | Alert Moderator

T.Saravanan
Posted on: 9/25/2012 10:47:33 AM

Level: Silver | Status: [Member] [MVP] | Points: 25

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. | Reply | Alert Moderator

Nkkppp
Posted on: 9/25/2012 11:58:12 AM

Level: Starter | Status: [Member] | Points: 25

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. | Reply | Alert Moderator

Hariinakoti
Posted on: 9/25/2012 1:08:53 PM

Level: Starter | Status: [Member] | Points: 25

Nice exolanation Saravanan

Thanks & Regards
Hari

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

Send mail using SSIS package

Replies

Reply - Please login to reply

Latest Posts