Hi everyone,

Can anyone advise me where to look to try to resolve this problem please?

I have a DTS job that runs each night to extract data from a UNIX system
onto a Windows 2000 server running SQL Server 2000. Before extracting the
data I drop tables from the previous run. Most nights this works fine, but
sometimes I get the following error (given in the job run log) on the first
extract job I run:

Step 'Drop table TEDTRAN_INPUT Step' failed

Step Error Source: Microsoft OLE DB Provider for SQL Server
Step Error Description:Timeout expired
Step Error code: 80004005
Step Error Help File:
Step Error Help Context ID:0

Step Execution Started: 27/09/2002 2:00:47 AM
Step Execution Completed: 27/09/2002 2:05:00 AM
Total Step Execution Time: 253.578 seconds
Progress count in Step: 0

The table only contains around 30,000 rows & is normally dropped in a couple
of seconds. There should be no other activity on the server as the extract
is done at 2am. All of the subsequent jobs, even dropping larger tables, all
work fine. There doesn't seem to be any messages in the server event log or
server 2000 logs. Is there anything else I can look at, or do, to find out
what is going wrong?

Regards,
Colin Shelton.
IT Services,
UCE, Perry Barr, Birmingham, B42 2SU.
Tel: 0121 331 5665
Email: colin.[Email Address Removed]MS Sql Server LazyDBA home page