Jaa


_DTSUPMCustomTask::get_NumRetries, put_NumRetries Property

The NumRetries property contains the number of retry attempts to be made after an SQL connection/query failure.

HRESULT _DTSUPMCustomTask::get_NumRetries( 
  long NumRetries
);
HRESULT _DTSUPMCustomTask::put_NumRetries(
  long NumRetries
);
Property NumRetries() As Long

Parameters

  • NumRetries
    [C++]

    [in] When putting the property, a long used to specify the number of retry attempts that will be made after an SQL connection/query failure.

    [out,retval] When getting the property, a long used to specify the number of retry attempts that will be made after an SQL connection/query failure.

Return Value

[C++]

This method returns an HRESULT indicating whether it completed successfully. See the Error Values section for more details.

[Visual Basic]

None.

Error Values

[C++]

This method returns S_OK (0x00000000) to indicate success and standard COM HRESULT error values to indicate failure. For more information about standard COM errors, see Standard COM Errors. Additional information may be available using the global Err object, which can be accessed using the API function GetErrorInfo. In particular, the GetDescription method of the IErrorInfo interface may return a text description of the error.

[Visual Basic]

This method sets the Number property of the global Err object to S_OK (&H00000000) to indicate success and to standard COM error values to indicate failure. For more information about standard COM errors, see Standard COM Errors. Additional information may be available using the global Err object. In particular, the Description property may contain a text description of the error.

Remarks

If the NumRetries property is set to 0 (zero), no retry attempt will be made. The minimum number of retry attempts is 0 (zero), the maximum number of retry attempts is 255. The default value is 10.

See Also

Other Resources

_DTSUPMCustomtask::CustomTask_Execute

_DTSUPMCustomTask::get_DTSTaskDescription, put_DTSTaskDescription

_DTSUPMCustomTask::get_DTSTaskImportStartDate, put_DTSTaskImportStartDate

_DTSUPMCustomTask::get_DTSTaskName, put_DTSTaskName

_DTSUPMCustomTask::get_DTSTaskTimeQuantum, put_DTSTaskTimeQuantum

_DTSUPMCustomTask::get_ProcessingType, put_ProcessingType

_DTSUPMCustomTask::get_RetryInterval, put_RetryInterval

_DTSUPMCustomTask::get_SourceName, put_SourceName

_DTSUPMCustomTask::get_SourceType, put_SourceType