If I need to clarify anything or post this differently, please let me know.:-)

Can you have an SSRS 2005 hitting the same ReportServer database that the 2008 is?

I think I just found it.

http://msdn.microsoft.com/en-us/library/aa964131(SQL.90).aspx

Never mind. I found them. My laptop had not been service packed. I installed SP2 and all is well.

Where can you download the standard reports for SQL Server 2005?

I think I found the answer. According to Microsoft documentation (below), it appears that subscriptions will continue to work after SSRS 2005 is upgraded to 2008. However, I...

You might try this tool, RSScripter. http://www.sqldbatips.com/showarticle.asp?ID=62 It is a great way to transfer reports from one server to another, but it will also script...

It might be parameter sniffing. If you do what Christopher suggested this will resolve the issue with parameter sniffing. I think there are other ways to resolve the...

Sorry, missed the part that they were inserts.

Queries could also be scanning a table instead of using proper indexes.

Thank you both.

Gift, I will pass along the info you posted. There are around 100 reports. I'll check to see if I have a query to...

You might check out the link below. Near the bottom he offers suggestions on how to avoid deadlocks.

http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx

OK.

Here's what I figured out. You can use the Export Column Transformation Editor in the SSIS Data flow to create an output file from the data flow. Basically,...

sthe4u,

Thanks. I might take a look at that as well. I did find Export column in the SSIS Data flow that says it is supposed to create an...

GavinC,

I guess I spoke too soon. I don't see a Write File Transformation. Is the task called something different?