Stored Procedure - usp_ETLExecutionLog_SSISConfigurations

Property	Value
Name	usp_ETLExecutionLog_SSISConfigurations_Insert
Schema	dbo
Is Encrypted	False
Ansi Nulls Status	True
Quoted Identifier Status	True
Description

Name	Data Type	Direction	Description
@ETLExecutionLogId	int(10, 0)	Input
@ETL_LogPoint	varchar(25)	Input

Name	Type
ETLExecutionLog_SSISConfigurations	Table
SSIS Configurations	Table

Name	Type
ETLExecutionLog_SSISConfigurations	TABLE
SSIS Configurations	TABLE

Object

Property

Value

Object

Property

Value

/****** Object: StoredProcedure [dbo].[usp_ETLExecutionLog_SSISConfigurations_Insert] Script Date: 03/09/2017 17:21:49 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
/*
Name:            Craig Love
Date:            11/18/2013
Company:        PragmaticWorks / HETGroup
Project:        EnterpriseDW
Description:
    Inserts a record into the [dbo].[ETLExecutionLog] table. This
    table is used as a wrapper for other custom logged items.
*/
CREATE PROCEDURE [dbo].[usp_ETLExecutionLog_SSISConfigurations_Insert]
    @ETLExecutionLogIdINT,
@ETL_LogPoint VARCHAR(25)
AS
SET NOCOUNT ON
BEGIN TRAN
BEGIN TRY
    INSERT INTO [dbo].[ETLExecutionLog_SSISConfigurations]
        (
        ETLExecutionLogId,
        ETL_LogPoint,
        ConfigurationFilter,
        ConfiguredValue,
        PackagePath,
        ConfiguredValueType
        )
    SELECT
        @ETLExecutionLogId,
        @ETL_LogPoint,
        ConfigurationFilter,
        ConfiguredValue,
        PackagePath,
        ConfiguredValueType
    FROM [SSIS Configurations] sc;
    COMMIT TRAN;
END TRY
BEGIN CATCH
    ROLLBACK TRAN;
    DECLARE @ErrorMessage NVARCHAR(4000);
    DECLARE @ErrorSeverity INT;
    DECLARE @ErrorState INT;
    SELECT
        @ErrorMessage = ERROR_MESSAGE(),
        @ErrorSeverity = ERROR_SEVERITY(),
        @ErrorState = ERROR_STATE();
    -- Use RAISERROR inside the CATCH block to return error
    -- information about the original error that caused
    -- execution to jump to the CATCH block.
    RAISERROR (@ErrorMessage, -- Message text.
               @ErrorSeverity, -- Severity.
               @ErrorState -- State.
               );

END CATCH;