I remember why my DTS package was failing for me under QA.

I was starting QA from EM and it was connecting me to the DB as the SQL logon...

In your DTS package, can you return the user id that it thinks it is using and confirm that that user has permissions to the file?

I had this exact same thing happen and it was because the file was being accessed with the logon credentials of the client (both cleint app and query analyser). It...

Where are you executing the DTS package from when you use the SQLProxyAccount?

In your DTS package, if you are referencing the excel file with a full path and drive...

Thanks scotttr.

The step that I was missing with the .DTS files was right clicking on the on the "Data Transformation Services" to open the saved .DTS file. I tried opening a new...

Thanks for the reply.

I had tried saving to floppy originally but was unclear of how to load from floppy at the new server. The article I reference above gives good...

Found a good article to do this:

http://www.sqldts.com/default.aspx?204

If you create an ODBC connection, test that it works correctly, and specify it as your "Data Source" in your connection string, do you see the same behavior?

Can you provide more details regarding your VB code? The Dim, Set, and command lines for the RS?

Since your SP runs fine in QA, I would check your connection. Are you using direct connection string or ODBC? What is your cursor type? I've had issues with ODBC...

Do you specify your connection string for your ADO object? In your post, you do not specify it when you are opening your recordset (rs.open [SQL statement], [connection]) so do...

Any recent hardware change? I had a similar problem when our RAID backplane failed. When it was changed out the controller firmware version with the new backplane was the issue....

I meant to add that in the case of an infinite loop on the server side, closing IE that invoked the page will terminate the session at IIS so that...

When the system is slugish for ALL IIS tasks, is this comment based on running other tasks through the same instance of IE? If you close your IE and re-open...

I don't know if this will help, but in the Server Network Utility, you can see the driver that is used for TCP/IP. Maybe try replacing it with a version...