In this step by step SSIS tutorial I will present how to using SSIS backup database. For this purpose I will use SSIS 2008 R2.
From SSIS Toolbox I drag and drop Back Up database task into control flow.
I renamed the item to Backup ITCoupleDW
I double clicked the item and Back up database task dialog box appeared. Click New connection button.
In the Connection Properties I type Connection name and Server name in this case it is local one (.)
No I will select the Database from the list i want to backup.
Now that we have connection and selected specific database and we change other options but in my case I will accept default values.and press OK button.
Let's test the package by running it. As you can see it went green and I checked the path for backup file and it was created.
I hope this tutorial will help in creating package that will help you with you backup strategy.