ExecuteSQLTask::TimeOut Property

 

Gets or sets an integer that indicates the maximum number of seconds the task can run before timing out.

Namespace:   Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask
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::UInt32

An Integer that indicates the maximum number of seconds the task can run before timing out.

A 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.

No code example is currently available or this language may not be supported.

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

Return to top
Show: