_DTSCacheWarmer::get_NumRetries, put_NumRetries Property [C++]

The NumRetries property is a read/write Long that specifies the number of retry attempts that are to be made after a SQL connection/query failure.

Definition

[C++]

Get method:

HRESULT _DTSCacheWarmer::get_NumRetries(
long NumRetries
);

Put method:

HRESULT _DTSCacheWarmer::put_NumRetries(
long NumRetries
);

[Visual Basic]

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 a 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 a SQL connection/query failure.

None.[Visual Basic]

[C++]

Return Values

These methods return an HRESULT indicating whether they completed successfully. See the Error Values section for more details.

Error Values

[C++] These methods return 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 property 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, no retry attempt will be made. The minimum number of retry attempts is 0, and the maximum number of retry attempts is 255. The default value is 10.

See Also

ETL Process for the Report Caching DTS Task

Scripting the Report Caching DTS Task

[C++]DTSCacheWarmer::CustomTask_Execute

[C++]DTSCacheWarmer::PersistPropertyBag_Load

[C++]DTSCacheWarmer::PersistPropertyBag_Save

[C++]DTSCacheWarmer::get_RetryInterval, put_RetryInterval

[C++]DTSCacheWarmer::put_SourceName

[C++]DTSCacheWarmer::get_SourceType, put_SourceType

[C++]DTSCacheWarmer::get_TaskName, set_TaskName

[Visual Basic]DTSCacheWarmer.CustomTask_Execute

[Visual Basic]DTSCacheWarmer.PersistPropertyBag_Load

[Visual Basic]DTSCacheWarmer.PersistPropertyBag_Save

[Visual Basic]DTSCacheWarmer.RetryInterval

[Visual Basic]DTSCacheWarmer.SourceName

[Visual Basic]DTSCacheWarmer.SourceType

[Visual Basic]DTSCacheWarmer.TaskName

Copyright © 2005 Microsoft Corporation.
All rights reserved.