http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660I didn't have a clue that the table was this big. I will probably need to rethink the way we do it. Thanks for the tip http://ayende.com/2303/that-might-take-a-while#comment2http://ayende.com/2303/that-might-take-a-while#comment2Wed, 11 Apr 2007 05:32:11 GMTOn large tables, it's usually more efficient to put the data flow in a for loop and chunk through it in blocks of (50k, 100k, etc.) rows. If you've got a sequential PK, then this is pretty easy. It's much easier for the query processor to deal with smaller chunks of data at one time, and SSIS likes it better too. http://ayende.com/2303/that-might-take-a-while#comment1http://ayende.com/2303/that-might-take-a-while#comment1Wed, 11 Apr 2007 05:11:23 GMT