How to Back up and Sending mail to SSIS notification

Introduction: In Chapter 1 we had learn how to create project in SSIS?

Description: Know here we will learn how to take Backup and send a mail using SSIS

First Step: – From Toolbox > Maintenance Plan Tasks > Drag Backup Database Task on to the Control Flow

Second step : – Double Click on Backup Database tool which is on Control Flow window. Back up Database Task window will appear on screen.

Third Step: – Click on New > Create a connection and give a name to your connection and select your Server name and click OK

Fourth Step :- We will select Database from drop down and Click OK

Fifth Step :- From Backup Database Task Window there are 2 options where to save the backup file we will select “backup database across one or more files” check box > click on ADD, It will ask us where to save the file in Local system and give the name of you backup file name > Click OK and set backup in compression format.

Sixth Step : – From Tool box > Control Flow items > Drag Send Mail Task and connect the Connector of Backup Database task to Send Mail Task (The Green line)

Seventh Step : – Double Click on Send mail task which is connected to Backup database task > Send Mail Task Editor will open go on mail from left hand side

Eight Step :- Click on SMTP Connection on same window and create new SMTP connection and click ok

Nine Step :- Know fill all the remaining data from Send Mail Task Editor to whom the mail will go, to whom we have to send, subject line, What will be the message, any attachment with mail and Click ok.

Tenth Step :- Again From Tool box > Control Flow items > Drag Send Mail Task and connect with the Connector of Backup Database task to Send Mail Task and right click on connector and set as Failure than config the send mail task using same smtp connection and with Failure message

And Last step :- Go on Solution explorer right click on you project name click Build

Thank you

Leave a Reply

Your e-mail address will not be published. Required fields are marked *