Hi All, I need to disable the index before loading the data and enable the index after loading the data using SSIS . Will it be as effective as dropping and recreating index ? Please share your opinion on this.

Enabling index is done with the rebuild command, which is essentially the same (both are parallel operations: http://msdn.microsoft.com/en-us/library/ms189329.aspx) However, you can rebuild the index online, meaning data will still be available when the index is being rebuild.MCTS, MCITP - Please mark posts as answered where appropriate.

Both are essentially the same except in the former i.e. disable/rebuild you dont have to worry about the index definition. Check this which has a related discussion. http://btsbee.wordpress.com/

Hi All, I need to disable the index before loading the data and enable the index after loading the data using SSIS . Will it be as effective as dropping and recreating index ? Please share your opinion on this. Hi, Two questions: 1. How many records you have to load? 2. How many existing records do you have in the destination table? Dropping an index in large table can be very expensive operation. If you are dealing with huge amounts of data, you'd better start investigating using table partitioning.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/