Is the file system task in an event handler, or is it a separate task on the control flow?

Thanks,

Simon

Hi,

If you're already copying the file then can't you just change the file system task to complete a "Move File" operarion rather than a "Copy File" one?

Or have i mis-understood...

Hi,

You need to look at the log files in the following directory:

C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles

(Assuming you're running 2008R2) Your directory may differ slightly. When the service starts or restarts...

Multiple tempdb files help to relieve latch contention.

See this link: http://sqlblog.com/blogs/adam_machanic/archive/2011/04/21/analyzing-tempdb-contention-a-month-of-activity-monitoring-part-21-of-30.aspx

Sorry... got pulled away from my desk as I was replying. I see you've gotten past this question now... 🙂

Sounds like you're not browsing to the correct URL to me. By default i think the URL is

http://YourServerName/reports

Make sure you're browsing to the report manager URL not just...

Hi,

If your recovery model is full and you don't take a log backup then your log file will fill the drive it is sat on. If you don't care about...

Hi,

There is a log file associated with SSRS that will tell you what the problems are starting the service etc. mine is located here:

C:\Program Files\Microsoft SQL Server\MSRS10_50.SQLEXPRESS\Reporting Services\LogFiles

Yours will...

No worries, glad you got it sorted.

What's the image source? Embedded/External/Database? Maybe sharepoint can't access the image location for the header.

Thanks,

Simon

I've not tried this but maybe you could. If you made each dataset its own report then had a master report that had these reports as subreports, then those that...

I wouldn't have said this was normal at all and certainly wouldn't be practical for us. Our t-log file would grow to be unmanageable if our backups were like this.

As...

Hi Jeff,

I do actually make use of a GROUP BY and a ROLLUP in the query behind the report but it's a full A4 page chart, not a table of...

Hi,

I'd fully endorse Coeo too if you're in the UK. We've had them in twice and they were really superb.

Thanks,

Simon

For me as a BI Developer/DBA i found that 463 was the easiest, then 461, then 462. YMMV.

All the information you need can be found from here:

http://www.microsoft.com/learning/en/us/sql-certification.aspx