Reorganize Index Task
When you insert, update, or delete records from tables, the indexes become fragmented and the performance suffers. To fix this, you can use this task in your SSIS packages along with other tasks such as bulk insert. The Reorganize Index task reorganizes indexes in SQL Server database tables and views and does the defragmenting of indexes by re-ordering leaf level pages and compaction. This task effectively runs the ALTER INDEX T-SQL command and uses the REORGANIZE WITH (LOB_COMPACTION = ON) clause in the command.
Here is the step by step method to configure this task:
1. | Drag the task on the Control Flow Designer panel and start configuring this task. First connect to the SQL Server. You use the ADO.Net Connection Manager ... |
Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
