Rebuild Index Task

The rebuild index task rebuilds indexes in sql server database tables and views. By using the rebuild index task, a package can rebuild indexes in a single database or multiple databases. If the task rebuilds only the indexes in a single database, you can choose the views and tables whose indexes the task rebuilds.

Step 1:

Drag and drop rebuild index task and edit it.

Step 2:

Give new connection as rebuild index task

Step 3:

Click on databases and select one database as AdventureWorks

Step 4:

In selections to select a table as dbo.singlemales

Step 5:

Execute a task