Can anyone please help? I am at a lost here.

I have 5 exactly the same scheduled DTS tasks running on DB server1.
These tasks are run from DB server1 and executes a query on SQL Table1
in DB server2. The output is sent to an Excel These tasks all run at
the same time and write to seperate error logs. I am running XP on all
boxes.

On some days I get a failure of anywhere from between 1 - 5 scheduled
tasks. Somedays everything works fine and the tasks perform flawlessly.
The only error is a "SQL Server does not exist or access denied".
Error in detail below:

The job [DQ: DTS Report] failed at 05/31/2006 01:00:22 on step 1 (DTS
Report). The message returned was [Executed as user:
TRADIANT\SQLservice. DTSRun: Loading... DTSRun: Executing... DTSRun
OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_1
DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259
(80004005) Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL
Server does not exist or access denied. Error source: Microsoft OLE DB
Provider for SQL Server Help file: Help context: 0 Error Detail
Records: Error: -2147467259 (80004005); Provider Error: 17 (11) Error
string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not
exist or access denied. Error source: Microsoft OLE DB Provider for SQL
Server Help file: Help context: 0 DTSRun OnFinish:
DTSStep_DTSDataPumpTask_1 DTSRun: Package ex ecution complete. Process
Exit Code 1. The step failed.]

I have changed the DB Server2 name using it's fully qualified name eg
DBServer2.company.com as well as the IP address. I still get these
problems. The user name and passwords to the server are working and is
current.

Can anyone offer any insights? I have scoured several forums and there
doesn't seem to be a definite answer to this problem.