USP_ETLREFRESHPARAMETER_GETOLAPDATASOURCEID

Retrieves the OLAP data source ID for the ETL refresh process.

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy



CREATE procedure dbo.USP_ETLREFRESHPARAMETER_GETOLAPDATASOURCEID

/* 
Retrieves the OLAP data source ID for the ETL refresh process.
*/

@ID uniqueidentifier

as

set nocount on;

select
    [OLAPDATASOURCEID]
from
    [dbo].[ETLREFRESHPROCESS]
where 
    [ID] = @ID;

return 0;