Skip to main content

Command Timeout

SSIS Command Timeout to use. Override the value here to change the default SSIS behavior.

The value is applied as the command timeout on the source components (OLE DB, ADO.NET, ODBC, Oracle and Teradata sources) in the generated data flows. The default 0 does not limit command execution time.

When to Change This Setting​

Keep the default 0 when source queries are allowed to run to completion regardless of duration. Set a timeout when a hung or long-running source query should fail the package instead of blocking the load indefinitely.

Notes​

  • This setting is part of the SSIS settings category.
  • The default value for this setting is 0.