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