Man... that was not an easy one. Took me almost half an hour to figure it out. THANKS!

WOTD: SQLS 2012 RC

You can download it at http://www.microsoft.com/download/en/details.aspx?id=28145.

Wow! Very smart!

Thanks -- I learned something...

Is your Report Server configured for your Windows login?

You may wish to check http://msdn.microsoft.com/en-us/library/ms156034.aspx.

One small trick: Under Start (or Windows or whatever it is in Win7) > Accessories > System...

If it ios not an extranet server, I would use Windows authentication.

One way how to avoid the problems with BETWEEN when working with dates is to use what we call DateId. It is an integer (only 4 bytes!) with a...

Eric M Russell (11/17/2011)

---

Dave62 (11/17/2011)

---

Jack Corbett (11/17/2011)

---

It's sad but I've seen code that is ripe for SQL Injection, commented it shouldn't be allowed and that if it was my decision...

It sounds like bad design of the service. Its purveyors may blame your network, and there indeed may be a problem; however, it is their duty to let you...

Are there any entries in the Event Log?

Not with the generic SSIS Excel Source. You would need a C# program that would use Interop...

On a well managed project you do code reviews. And if you are the reviewer, you do your best to be polite and helpful but it is your duty...

Yes, it could - just could -, but it is difficult to tell with this dearth of detail.

unpleasant

Use the suggested staging table (may be temporary) and SELECT DISTINCT.

What kind of 'service' is it? Windows service? WCF service? A permanently running SSIS job?