Are you sure the reason the report runs so long is the query (data retrievel) and not the generation of the report?

I see two CASE statements, but only one END.

A more practical example would be useful to understand what you're trying to do.

Can you share some sample data, table definations and desired output?

This article has all the answers:

What’s the deal with Excel & SSIS?

You can use a derived column to replace the NULL values:

(ISNULL(mycolumn)) ? " " : mycolumn

Or if the source allows it, change it in the query.

BETWEEN uses inclusive ranges, so any date equal to '01/01/2000 00:00:00:000' will also be selected.

Project deployment model:

* there is a real concept of "project" --> might force you to do more source control

* project connection managers

* parameters & environments (I find those eventuelly more...

OK, why don't you add the header value into a column with a derived column component?

Whoa whoa, did this thread suddenly become a VBA thread? How did that happen? 😀

You should be able to get the values out of the cells. I've done it in...

pietlinden (8/12/2013)

---

Just wondering, it looks like Excel 2013 is going to be really cool for BI... especially stuff like GeoFlow etc for doing sort of "time lapse" sales analysis. ...

raghavender.2369 (8/12/2013)

---

thanks for response...

In short , I have excel sheet which has 32 tables... each table has header , the column in the header need to be stored...

You need vbs script for that:

http://superuser.com/questions/110991/can-you-zip-a-file-from-the-command-prompt-using-only-windows-built-in-capabili

http://superuser.com/questions/201371/create-zip-folder-from-the-command-line-windows

And what exactly would you be calling...

Why would you do this with a database engine?

Languages like .NET are far better suited for this.

Prevent SQL Server Reporting Services Slow Startup[/url]