ExecuteSQLTask::TimeOut Property
Gets or sets an integer that indicates the maximum number of seconds the task can run before timing out.
Assembly: Microsoft.SqlServer.SQLTask (in Microsoft.SqlServer.SQLTask.dll)
public: property unsigned int TimeOut { virtual unsigned int get() sealed; virtual void set(unsigned int value) sealed; }
Property Value
Type: System::UInt32An Integer that indicates the maximum number of seconds the task can run before timing out.
Implements
IDTSExecuteSQL::TimeOutA value of 0 indicates an infinite amount of time. The default value of this property is 0.
The following example creates an ExecuteSQLTask, then shows the default settings of the properties, including the TimeOut, using the TaskHost. It then sets the value of some properties to show how to set property values.
Sample Output:
BypassPrepare False
CodePage 1252
Connection
ExecutionValue
IsStoredProcedure False
ParameterBindings Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ParameterBindings
ResultSetBindings Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ResultBindings
ResultSetType 1
SqlStatementSource
SqlStatementSourceType 1
TimeOut 0
--------------------------
New value of Source and SourceType: myVar, 3
New value of ResultSetType: 4