Try running the following to update your space usage:

DBCC UPDATEUSAGE ('your_db_name') WITH NO_INFOMSGS

If you schedule a dts package then it runs under the login that the SQL Server Agent is running under.  Make sure this login has the correct permissions on the...

Is the server in the DMZ?  If so it will not resolve the name.  You will have to use the IP.

I have done something similar in the past with two dts jobs.  Job one reads a list of servers from a table and creates a batch file of dtsrun statements...

#temp tables are created in the tempdb and are only available during the current connection.  Something like the following would not work:

begin

create #temp

commit

select * from #temp

From BOL:

Local temporary tables have...

DTS runs as a command line object, so it does not use the memory reserved for SQL Server, but the free memory on the system.  You might try backing down...