| Lock | Scope | Default Isolation (SQL) | How SSIS Enforces It | |------|-------|--------------------------|----------------------| | | Read‑only, multiple readers | READ COMMITTED | OLE DB/ADO.NET adapters open with READ COMMITTED (no special setting). | | Update (U) | Intent‑to‑write, exclusive write after read | READ COMMITTED SNAPSHOT (rare) | Not directly exposed; you must use a Script Task that runs SELECT … WITH (UPDLOCK) . | | Exclusive (X) | Full write lock, blocks reads & writes | SERIALIZABLE or REPEATABLE READ (via IsolationLevel = Serializable ) | Set TransactionOption = Required + IsolationLevel = Serializable on the Package or Connection Manager . | | Intent‑Share / Intent‑Exclusive | Hierarchical lock hierarchy (SQL Server internal) | Managed automatically | No direct SSIS UI, but you can view via sys.dm_tran_locks . |
Legacy SAP connectors often have throttling limits. However, using the exclusive data flow mode (mapped to the 541 handler) bypasses SAP’s default pagination, allowing full-throttle extraction directly into a staging area. ssis 541 exclusive