February 11, 2009 at 8:31 am
I didn't check msdn yet (of course I will to know!) but I did find it funny to have an isolationLevel name that way!
Of course I want this to happen to the data! :w00t:
This can be found under SSIS SP3, Execute SQL Task, Properties, IsolationLevel
February 11, 2009 at 8:55 am
I agree this is a funny name. I didn't know that Chaos wa a valid isolation level. I'm not sure I even get it after reading the explanation. It would sound bizarre to try an explain this to a project manager " Well we decided to implement a chaos level of transactional isolation despite this level not seeming supported by SQL according to BOL" I can image the response to this!!
Francis
February 11, 2009 at 9:00 am
Per MSDN, it's a valid selection. And, yeah, I don't think I would want to make the business case on ths one.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 11, 2009 at 11:57 am
That is great. I'll see if I can figure out who did make the case for this one.
February 11, 2009 at 12:27 pm
Those Isolation levels are specific to SSIS because SSIS uses Distributed transactions which require a resource manager MSDTC by default. You don't have to use it you could call a stored procedure and use the ANSI SQL transactions which is a Unit of work while the distributed transactions are none atomic so a resource manager is needed to convert the transactions to a unit of work which is atomic.
Check below for the SSIS isolation levels definitions.
Kind regards,
Gift Peddie
February 11, 2009 at 1:53 pm
I have to say I kind of like it. It sure sounds a lot more like what it really is than the SQL Server name for it (a.k.a NOLOCK). I'd think that darned thing would be a lot less popular if your select read
SELECT MyColumn from MyTable with (CHAOS).......
and by the way - I'm thinking they're actually referring to the CHAOS state from mathematics, as it relates to locking, deterministict queuing, etc....
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply