You might want to use Performance Monitor to monitor memory usage. Your variability in execution time may be reflected in memory and/or thread usage by DTS. We use DTS...
Depends on your version of SQL Server and how you configured your databases and when. Older versions of SQL Server required you to preallocate physical disk space. While you could...