The BBDW refresh process does not use NOLOCK

It appears that the BB packages do not utilize nolock in queries to the source transactional database (CRM). For the purposes of loading a data warehouse that is basically a snapshot at a point in time, why wouldn’t it use dirty reads or NOLOCK?

Suggestions for changing the architecture of the software an be entered into our Ideas Portal.   The request documented in this article would best be covered in this Planned Idea to increase ETL reliability: 

Steps to Duplicate

1) Turn on nolock for the session
2) Try to use NOLOCK while loading a data warehouse


 Blackbaud CRM

Was this article helpful?