Wow, I must be the only one with this problem. With in-line T-SQL the SSRS report runs in 30 seconds but the report with same SQL in a Stored Proc...

also got the "Failed to save package file "C:\WINDOWS\TEMP\tmp96.tmp" with error 0x8002802B" when I tried to create a SSIS package. But when I installed msxml6.msi, I got another error stating...