SSIS slows down the server; old DTS work fine
Fellows,

Recently I migrated a server from SQL Server 2000 to SQL Server 2005, initially keeping the old DTS, but yesterday the time came for me to migrate the DTS to SSIS packages. It all went pretty straightforward but as soon as the job that would run the packages started, the server got too slow to function and the packages had to be stopped. The DTS packages run just fine.

Where I ought to start investigating, where to look?
What are the most probable causes for this problem?
Are there any configurations that I should mind?

SSIS slows down the server; old DTS work fine
===

Fellows,

Recently I migrated a server from SQL Server 2000 to SQL Server 2005, initially keeping the old DTS, but yesterday the time came for me to migrate the DTS to SSIS packages. It all went pretty straightforward but as soon as the job that would run the packages started, the server got too slow to function and the packages had to be stopped. The DTS packages run just fine.

Where I ought to start investigating, where to look?
What are the most probable causes for this problem?
Are there any configurations that I should mind?
