Could you post some more detail about the table, such as what the "in & out columns" hold?

No, the error codes from DTS are not helpful at all...

I would look at some things:

**What other processes are running on each server at the time the job is run?

**Is...

DTS does not exist in SQL Server Express 2005. You would have to use a higher version of SQL Server 2005 or use SQL Server 2000.

Here is a link...

I would use the Execute Process task and call your Unzip utility as you would from the command line.

You don't have to convert the data. To get all of the records for the 13th and 14th of June, use the following code

where Date >= 13/06/2006 and Date...

Have you tried this script in the library:

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1527

Importing Excel files has given me more pain over the years then I care to remember. Save the Excel file to a csv and save yourself some pain.

Can you paste the servername into the "Add connection" window.  I would try that.

If the services are off you won't see the Server Name in the pick list.