So either no one reads this blog or no one knew he answer, or maybe you are too shy to make a comment
Anyway the answer is Chaos and you can find it in DTS, when you right click in the DTS designer then select Package Properties and after that click on the Advanced tab.
you can select it from the Transaction Isolation dropdown (see pic)
Just if anybody wants to know:
ReplyDeletehttp://www.databasejournal.com/features/mssql/article.php/3327681
# "Chaos" - like "Read Uncommitted," permits viewing uncommitted changes, but without holding update locks until the end of transaction. Due to its lack of support on the SQL Server platform and inability to roll back, it is rarely used.
PS: this is a manual trackback :)
I must admit that I have never used Chaos in any of my DTS packages
ReplyDeleteStill a niece piece of SQL Server trivia