There is probably an error in your package somewhere.  SSIS won't let you run your package if there is a design time error.

Did you find where 7-Zip created the original zip file?  What is the setting for RequireFullFileName?

Checking our setup, RequireFullFileName is false, Executable is gzip.exe.

On the server, I made sure that...

I did think of one thing, what did you set the working directory to in the Execute Process Task?  That should be where the zip file would be created.

Two things.  One, I don't know your zip program so you will have to read the help files for it to figure how to use it.  Second, we really have...

This may also be a good time to explore upgrading to SQL Server 2005 where you can actually store XML data using the new XML data type.

Thought I'd check and see how your zip process is coming.  I will take a bit of time and work on the next two pieces of your puzzle for renaming...

That is one you will have to play with, just like I did with our zip utility.  That is one reason I like SSIS, I can disable all the other tasks...

Opps.  Almost forgot, you will need a script task as well.  This will run before the file system task.

You now need a Sequential Container (actually you don't but it makes things easier).  Connect your Data Flow task to this container such that this container (and its contents) execute...

I will throw this one thought out to you.  You are trying to change from a Case Sensitive collation to a Case Insensitive collation.  In this database, you have at...

I'd change directions a bit.  One, is there a network share on the server that you can access from your desktop and the server using a UNC (\\Servername\Directory[\SubDirectory ...]? ...

I assume that you hardcoded the filename and destition.  This package will eventually run on the server, correct?

First, quick question, what did you name the file and where are you putting it (okay, actually two questions).

I think the easiest way to work you through this is a step at a time.  I was trying to list all the steps you need to complete, but I...

Does this mean that CurrentDate is like this: 2007-07-01 13:03:01.133?

Not familiar with 7-zip, does it have a command line capability?