http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660As Jon pointed out, you can disable tasks within a container, and the SSIS engine will bypass them. As for hammering away at the machine, there's not much you can do other than limit the size of the caches for lookup tasks (which SSIS does seem to respect). At the end of the day, you need to have an idea of the size of the datasets that you're dealing with, and tweak the components appropriately (e.g. dumping intermediary data into a db staging table vs staging the data in memory). http://ayende.com/2315/ssis-you-really-dont-need-all-this-data#comment5http://ayende.com/2315/ssis-you-really-dont-need-all-this-data#comment5Tue, 17 Apr 2007 02:51:13 GMTI love SSIS. I mean that completely sarcastically. Besides the non-deterministic nature of it, one of the other things I love about it is that there seems to be no real way of telling it not to use every single resource on your machine when running. It was great to have it hammer my dev workstation for 20 minutes, and either succeed, or fail silently. http://ayende.com/2315/ssis-you-really-dont-need-all-this-data#comment4http://ayende.com/2315/ssis-you-really-dont-need-all-this-data#comment4Mon, 16 Apr 2007 01:36:35 GMTAyende, You can try and disable individual tasks if you want to. http://ayende.com/2315/ssis-you-really-dont-need-all-this-data#comment3http://ayende.com/2315/ssis-you-really-dont-need-all-this-data#comment3Mon, 16 Apr 2007 00:40:33 GMTIt is not readable in purpose, I am afraid. What it is showing is a completed container with only part of its contained tasks completed. http://ayende.com/2315/ssis-you-really-dont-need-all-this-data#comment2http://ayende.com/2315/ssis-you-really-dont-need-all-this-data#comment2Sun, 15 Apr 2007 21:56:11 GMTThe pic's not readable. Any chance of a better copy? http://ayende.com/2315/ssis-you-really-dont-need-all-this-data#comment1http://ayende.com/2315/ssis-you-really-dont-need-all-this-data#comment1Sun, 15 Apr 2007 16:18:00 GMT