From the course: SQL Server Integration Services

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Maintenance tasks

Maintenance tasks - SQL Server Tutorial

From the course: SQL Server Integration Services

Start my 1-month free trial

Maintenance tasks

“

- [Narrator] There's one more type of task that I want to look at as an example of the wide variety of things that you can do with an Integration Services Package. The maintenance tasks perform administrative functions, such as backing up and shrinking SQL Server databases, rebuilding and reorganizing indexes, and running SQL Server agent jobs. We've seen the back up database task applied to the Kentico database. So, let's do something a little bit different this time, and use the rebuild index task to go through all the indexes in the Wide World Importers database, and reconstruct them. Just like with the other examples in this chapter, I'm going to compartmentalize the process by creating a new package. I'll right click SSIS Packages, choose new package, and then I'll right click that package and rename it. I'll call this one Rebuild Index. I'll press enter, and press yes to dismiss this dialogue box. Then we need to find the rebuild index task in the toolbox, I'll scroll down into…

Contents