Friday, March 9, 2012

OLE DB Source and Isolation level

Is there a way to define Connection Manager with Read Uncommited isolation level? I do not want to specify (nolock) in all my commands and instead want to give a generic defenition at the Connection level.

Is this possible?

if i'm not mistaken, transaction isolation levels can only be set within a t-sql transaction.

No comments:

Post a Comment