How to create schedule backup using SSIS package

Step 1:- Open Sql Server Management Studio – Chapter3

Step 2:- Start Sql Server Agent – Chapter 4

Step 3; – Right click on Sql Server Agent > New > Job

Step 4:- On Job Property Window go on > Step > click new >Give the name and

Select Type – “Sql Server Integration Services Package”, Select Run as = “Sql Server Integration Services Package”, General Tab – Package source: – It having 3 options go for “File system”

Package: – Browse and Select your package where you saved

Step 4:- On Job Property Window go on > Schedule > click new >Give the name

Configure the schedule by selecting: – Schedule Type, Frequency (Daily Weekly Monthly), at what time we have to start timing, Start Date, and End Date.

Click ok

We had done with the Scheduling of Backup using SSIS package

Thank You

Leave a Reply

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