Guys, For those of you who needs to go beyond Excel 2003 65000 rows or so limit, you can feed a pivot table with SQL server data.

I provide a couple...

Samuel Vella (8/13/2008)

---

David,

If you're using reporting services and users have web access to run reports then reports can easily be integrated into Excel (not sure about Excel 2000) using a...

Hello,

This article is getting unprecedented proportions.

How could we have MS SQL engine development database guys participating in the discussion If they are not yet already doing so or watching...

Too bad, I found this handy to keep a virtual server test database slim.

I do not regret...

Jeff Moden (1/31/2008)

---

Philippe Cand (1/31/2008)

---

Folks, there's absolutely no guarantee that MS will keep a particular method, function, stored proc, or functionality the same. I'll give you one of the...

I will derail this conversation and give it another spin.

Wether or not something is supported by Microsoft does not make it safer.

It is all about probability and bugs.

What is...

Yep, looks there are uncertainties in this approach.

It is very database engine centric while mind opening. I keep this article in mind as valuable.

I just thought it could be...

Jeff, thanks for this article I learn something new.

I was relying on Reporting Service reports, cubes and MDX to do the running total for me. This article shows me a...

See this

http://sqlblogcasts.com/blogs/simons/archive/2006/01/05/SSIS-64-Bit_2C00_-Excel-and-Access.aspx

It has a link to another post where more details are discussed. 😉

Yes please, give us a link where we can get the full article, full screen shots and a link to download the working sample package.

This really is a great article....

Great, It works perfectly.

I just have to put together the mechanism with the variables.

so instead of an URL not supported by JET, use an UNC

In my example I simply...

That would be creating on the fly a new Excel in SharePoint doc library with a path similar to this

http://smportal.onsemi.com/C10/Reporting%20Projects/Development%20Process%20and%20Templates/MyWorkbook.xls

Hello,

I like this article. Do you think that I could target a SharePoint portal document library?

Also, I would like the possibility to create a VBA module in addition to the...

Same...

Rasool Omidakhsh (11/16/2007)

---

Ok we can add multiple schedule to a job. But can we do conditional schedule? Can we for example have a schedule for everyday except the last Thursday...