This SSIS control flow task allows developers to easily drop and create indexes associated with any given table which is especially useful for large data loads typically in data warehousing applications.

It is a widely adopted practice to drop all indexes relating to fact tables just be fore executing the load task and re-create them back just after load has completed. Doing this can is most cases improve loading performance especially if the table being loaded has a large number of indexes.

The task uses a ADO.Net connection to query the sys.indexes system table and construct the respective DROP INDEX and CREATE INDEX statements pertaining to the indexes associated with the specified table. These statement are stored internally within the task object as strings. The string containing CREATE INDEX statements can then be assigned to a package variable that can be later used within an Execute SQL task to re-create the indexes.

A property editor user interface is available on the task that can be used by the developer to configure the task.

See Documentation tab for more details.

Last edited Jul 31, 2014 at 10:29 AM by rarpal, version 10