Import SQL Server Use No Lock
Overview
Import SQL Server Use No Lock is a Source Import parameter that controls the use of the NOLOCK hint in import packages for SQL Server. 0 - No, 1 - Yes.
Function
Use this setting to keep source import SQL behavior consistent across the project. AnalyticsCreator uses this value when no custom value is saved for the project.
Access
The parameter is maintained from the Parameters list in AnalyticsCreator.
How to access
Navigation tree
Parameters->List Parameters
Toolbar
Options->Parameter
Diagram
Not opened from the diagram.
Visual element
Parameter list
Default value
0
Custom value
Not set.
Where it is used
This parameter belongs to the Source Import group and is used when AnalyticsCreator applies source import SQL behavior.
| Setting | Value |
|---|---|
| Technical parameter name | IMPORT_SQLSERVER_USE_NOLOCK |
| Default value | 0 |
| Custom value | Not set. |
Parameter groups
| Group |
|---|
| Source Import |
| Profiling |
| Import |
