RS 2005 Transaction isolation level

[SQLScholar]

Hey all,

I have a reporting server that has a table that i have set up so that via an SSIS package it can be having data uploaded at any time.

The upload conists of holding tables followed by a SP that opens a transaction and uploads the data into the tables used by SSRS.

Now if the last bit is still running - will this cause any kind of locks that will stop SSRS from reading the data?

If so can i stop this by setting an isolation level in SSRS? What Isolation level do you recommend? Snapshot? I dont want a dirty read, but a clean read from before the upload transaction started.

Many thanks

Dan

Dan

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[xlbo]

typically SSRS will read what is there - I would've thought that you need to set isolation level in SQL Server rather than SSRS

I'd go for snapshot iso level - that way reads are not prevented and you don;t get any data that has been modified during the current transaction if it is still in progress

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question