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
 SQL Server Administration (2005)
 BCP

Author  Topic 

shimo
Starting Member

2 Posts

Posted - 2010-04-22 : 11:55:12
There is a way to increase the number of threads or (equivilent) to process data imports more quickly. I can't remember how or where to change the settings.

Example I have 10 processes importing tables in a dts package. It only run 2 or 3 at a time. How can I change it so that it will run 5 at a time?

shimo
Starting Member

2 Posts

Posted - 2010-04-22 : 12:06:51
Moderator,

Can you move this post to SQL Server 2000 Administration? I put it in the wrong place.
Go to Top of Page
   

- Advertisement -