I have ran the queries multiple times at many points during the day - same response times.

The queries are returned into text, not a grid.

Servers are in the same room,...

Both servers are using the same character set, sort order and accent order.

Sorry about that - title should read - 'faster than new', not 'faster than old'

Ok, I had to do some research on what other people were doing, but here's the conclusion:

1. Permissions were changed on the drive where the database resides and not rebooted

2. ...

I have plenty of 'growing' space.  I run a system that needs all of the processing power that it can have.  I don't want to take the hit of the...

I always turn off the automatically grow and shrink options on the data and transaction files.

I also tried to create a new maintence job and just backup the problem database.  Same error.

I also tried to create a new maintence job to optimize the database.  Same Error.

I...

Looks like it was an issue on the source server.  I recreated the DTS job exactly and it failed the same way again. 

I added an ORDER BY clause to...

The scheduled task runs about 4-5 DTS jobs, each is a seperate step in the job. 

The one that fails is the second one.

I can run the job from the...

It is not a text file, but another server's database.

When it works, I do not run it though a client, but directly on the server.

The only time the task fails...

The SQL agent logs into the local account, just like SQL server. 

The local account is still the same as yesterday.

I can run other DTS packages that access the same...

If the data was bad on the source server, then why would I be able to run the DTS package manually?

The collations didn't match up.  I didn't realize that you could chose collation at the column level.  Thanks.

The collations didn't match up.  I didn't realize that you could chose collation at the column level.  Thanks.

I replaced the following line :

PullDate = "2005-05-05"

 with the following code :

 Set oConn = CreateObject("ADODB.Connection")

 oConn.Open "Driver={SQL Server};Server=(local);Trusted_Connection=yes;"

 Set oRS = CreateObject("ADODB.Recordset")

 oRS.Open "SELECT COL_DAT FROM PULLDATE", oConn

 PullDate = oRS(0)

 oRS.Close

 oConn.Close

 Set oRS =...