USP_OLAPETL_LOGETLEND
Logs the end of an ETL process
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SSISEXECUTIONINSTANCEGUID | uniqueidentifier | IN | |
| @SSISPACKAGENAME | nvarchar(255) | IN | |
| @NUMROWSADDED | int | IN | |
| @NUMROWSUPDATED | int | IN |
Definition
Copy
CREATE procedure dbo.USP_OLAPETL_LOGETLEND
@SSISEXECUTIONINSTANCEGUID uniqueidentifier,
@SSISPACKAGENAME nvarchar(255),
@NUMROWSADDED int = 0,
@NUMROWSUPDATED int = 0
as
set nocount on;
UPDATE
dbo.ETLHISTORY
SET
ETLENDTIME=GETDATE(),
COMPLETED=1,
NUMROWSADDED = @NUMROWSADDED,
NUMROWSUPDATED = @NUMROWSUPDATED
WHERE
SSISEXECUTIONINSTANCEGUID = @SSISEXECUTIONINSTANCEGUID
AND
SSISPACKAGENAME=@SSISPACKAGENAME
;