USP_OLAPETL_LOGETLSTART

Logs the start of an ETL process

Parameters

Parameter	Parameter Type	Mode
@OLAPDATASOURCEID	uniqueidentifier	IN
@ETLCONTROLID	int	IN
@ISPARENT	bit	IN
@DATAWINDOWOPEN	datetime	IN
@DATAWINDOWCLOSE	datetime	IN
@SSISPACKAGENAME	nvarchar(255)	IN
@SSISPACKAGEPATH	nvarchar(255)	IN
@SSISUSERNAME	nvarchar(500)	IN
@SSISMACHINENAME	nvarchar(500)	IN
@SSISEXECUTIONINSTANCEGUID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_OLAPETL_LOGETLSTART

@OLAPDATASOURCEID uniqueidentifier,
@ETLCONTROLID int,
@ISPARENT bit,
@DATAWINDOWOPEN datetime,
@DATAWINDOWCLOSE datetime,
@SSISPACKAGENAME nvarchar(255),
@SSISPACKAGEPATH nvarchar(255),
@SSISUSERNAME nvarchar(500),
@SSISMACHINENAME nvarchar(500),
@SSISEXECUTIONINSTANCEGUID uniqueidentifier

as

set nocount on;

-- log etl start information

insert into dbo.ETLHISTORY
(
OLAPDATASOURCEID,
ETLCONTROLID ,
ISPARENT,
DATAWINDOWOPEN ,
DATAWINDOWCLOSE ,
SSISPACKAGENAME ,
SSISPACKAGEPATH ,
SSISUSERNAME ,
SSISMACHINENAME ,
SSISEXECUTIONINSTANCEGUID,
ETLSTARTTIME
)

VALUES
(
@OLAPDATASOURCEID ,
@ETLCONTROLID ,
@ISPARENT ,
@DATAWINDOWOPEN ,
@DATAWINDOWCLOSE ,
@SSISPACKAGENAME ,
@SSISPACKAGEPATH ,
@SSISUSERNAME,
@SSISMACHINENAME,
@SSISEXECUTIONINSTANCEGUID ,
GETDATE()
);

-- clear out the DATAWINDOWREFERENCE in preparation for next run (used by the ETL to dermine the data window) 

update dbo.OLAPDATASOURCE
set DATAWINDOWREFERENCE = null
where DATAWINDOWREFERENCE is not null; 

return 0;