_DTSTransactionImport::get_QueryInterval, put_QueryInterval Property [C++]

Article
11/12/2009

The QueryInterval property is a Long that identifies the number of minutes in the query interval.

Definition

[C++]

Get method:

HRESULT _DTSTransactionImport::get_QueryInterval(
long QueryInterval
);

Put method:

HRESULT _DTSTransactionImport::put_QueryInterval(
long QueryInterval
);

[Visual Basic]

Property QueryInterval() As Long

Parameters

QueryInterval[C++]

[in] When putting the property, a long that contains the number of minutes in the query interval.
[out,retval] When getting the property, a long that contains the number of minutes in the query interval.

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

A value of zero (0) will issue a straight select against the source tables. For any value greater than zero (0), the task will incrementally import the transactions in groups as determined by the query interval value. For example, if the query interval is 25 minutes (the default value) and the first transaction was logged at 1:30am, the transaction data import task imports all transactions logged between 1:30am and 1:55am, then it would import transactions between 1:55am and 2:20am. This pattern would continue until the current time is reached, at which point the task stops.

If the transaction database is in a different time zone than the Data Warehouse, the import will cease at the current time of the import, when converted into the time zone of the transaction database. For example, if the transaction database is in the EST time zone, the Data Warehouse is in the PST time zone, and the current time is 8:00am in PST, the import will cease when the query interval reaches 8:00am in EST.

Values can range from 0 to 2147483647 (LONG_MAX).

The default value is 25 minutes.