Tuesday, June 14, 2011

What are the maintenance Tasks in SSIS ?

Maintenance Tasks are the task which can be used to maintain database administration activities. IT contains the task which performs the SQL Server agent tasks.
SSIS contains the task for backup, restore and job executions functionality of SQL server management studio. These task help to automate the maintenance of database.
It has the task like index rebuild, shrink database update statistics.

No comments:

Post a Comment