You might find that when you convert an Excel file to .csv (whenever possible) it might work a little better. I've come across this in the past. Also,...

I've found the best way is to just dig in. There are tons of great articles here at SSC - I don't know what I would have done without...

Very nice article. Shows us very quickly how to create reports. You can download Report Builder 2.0 to be used with SSRS 2008 (MS acquired Dundas charting). ...

Just another great article. I've recently discovered Window functions in SQL Server 2005 and they certainly eliminate some of the overhead caused by subqueries and allow me to get...

Excellent article. I applied your example to my situation and it greatly reduced the time the SSIS package ran and eliminated errors and problems I was having.

We are...

I guess I would like to know what you mean by "haven't paid their dues"? I think one thing that is important to avoid is to be completely thrown...