Sql server maintainance task

Back Up Database Task: This task will allow you to backup a one or many SQL Server databases.

Check Database Integrity Task: This task will allow you to check the integrity of all the objects in one or many SQL Server databases.

Execute SQL Server Agent Job Task: This task allows for the execution of a SQL Server Agent job.

Execute T-SQL Statement Task: This task is similar to the Execute SQL Task, however it only supports
 Transact SQL Statements. It should be used for SQL Server specific SQL statements.

History Cleanup Task: This task allows for the cleanup of historical activity data. It will cleanup the history for database maintenance plans, backup activites, restore activities and SQL Server agent jobs.

Maintenance Cleanup Task: This task allows for the cleanup of backup files, and the reports of maintenance plans.

Notify Operator Task: This task allows SSIS to notify SQL Server Agent operators. They can be notifies by email, pager, or netsend.

Rebuild Index Task: This task will rebuild an index or indexes on one or many databases.

Reorganize Index Task: This task will reorganize an index or indexes on one or many databases.

Shrink Database Task: This task will shrink the size of the SQL Server database data and database log files.

Update Statistics Task: This task will update the statistics for one of many tables in one or many databases.