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...

We could use additional info in order to help you.  The DDL for the table(s) and some sample data will go a long way to generate some suggestions to help...

First, the query without the dbo.MyTab works as expected in SQL Server 2005.  I also ran it under SQL Server 2000 and got the unexpected result you reported.  I then...

Sergiy,

You also seem to have trouble recognizing the humor in Jeff's and David's posts.