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?

Two questions I need answered first.  One, what is the format of the date in Created?  Two, what software are you going to use to zip the output file?

We are...

Try this against your sample data:

select

    item,

    vendor,

    sum(case when year(entered_date) = 2005 then sales else 0 end) as TotalSales2005,

    sum(case when year(entered_date) = 2006 then sales else 0 end)...

Unfortunately, I can't see your sample data.  If you can post it as a series of insert statements that could be cut and pasted like your table DDL, that would...