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.
| Author |
Topic |
|
osghs
Starting Member
1 Post |
 Posted - 2005-08-04 : 16:51:23
|
| I have job that run DTS with several steps. For some reasone, the DTS starts to work very slow. it used to run in 30 seconds while transfering 300000 records and now its take several hours.there is no problem of disk space and no problem of locks.Help please |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2005-08-04 : 18:56:52
|
| Welcome to the group....What changes have been made to the destination table since the task was created? For example, adding of indices will slow the record insertion process. Cheers,Tim |
 |
|
|
|
|
|
help