Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  SSIS Package slow because of "progress window"

Author  Topic  shinaco Starting Member 6 Posts Posted - 2010-10-27 : 11:24:44 Hello I am using SQL Server 2005. I am new to SSIS Packages, altough I have some experience with DTS packages. So I created this package with SSIS that has a couple of nested for-each loops. It works well, except for the fact that when I run it, the information in the "progress window" gets very extense and it eats up my RAM memory, making the package progressively slower, so that forces me to eventually stop it and restart it again (it is designed in a way that it can start where it left off) so it regains the speed it had at the start. How can I keep this from happening? I.E., keep that window from appearing at all or have it report less detailed information. Thank you very much in advance for your help. Shinaco