Input Data tool Queries should not lock the database

[jpboyd58]

When users execute a sql statement via an input tool, the tool should be smart enough to invoke the (nolock) hint to avoid any database locking when querying a SQL database. Most users aren't advanced enough to understand how to do this in the SQL statement. It should be done automatically or at the very least, a check box option for user.

[Claje]

Hi,

Out of curiosity, have you tried the "Read Uncommitted" option in the Input Data tool?

My understanding is that this provides equivalent functionality to the (NOLOCK) hint, and this is a checkbox within the tool itself.

[jpoz]

@Claje is correct, the read uncommitted checkbox allows for this functionality. It is also not always desirable to read uncommitted rows so we don't do this by default.