SQL Server Integration Services includes log providers that you can use to implement logging in packages, containers, and tasks. With logging, you can capture run-time information about a package,
By Default logging applied any package sysssislog table created in our database.



 
Now I want to show by changing Table and SP To Store Logging data into customizing Logging table.

There is a predefined SP(sp_ssis_addlogentry) to capture package execution log store data into sysssislog table.This is Internal operation.

But we can change Table name and accordinly need to change in SP also..

Example:  I am changing sysssislog to SSISDataFlowExecutionLog

Step1:
Here is creating SSISDataFlowExecutionLog table

select top 0 * into SSISDataFlowExecutionLog from sysssislog

Step2:
I am changing SP according to new Table(SSISDataFlowExecutionLog)

ALTER PROCEDURE [dbo].[sp_ssis_addlogentry] 

   @event sysname
,  @computer nvarchar(128)
,  @operator nvarchar(128)
,  @source nvarchar(1024)
,  @sourceid uniqueidentifier
,  @executionid uniqueidentifier
,  @starttime datetime
,  @endtime datetime
,  @datacode int
,  @databytes image
,  @message nvarchar(2048)
AS 

INSERT INTO SSISDataFlowExecutionLog
(event,computer,operator,source,sourceid,
executionid,starttime,endtime,datacode,databytes,message)

VALUES (@event,@computer,@operator,@source,
@sourceid,@executionid,@starttime,@endtime,@datacode,@databytes,@message)

RETURN 0

STEP 3: 

Now i am deleting predefined table sysssislog.Because i am changed to SSISDataFlowExecutionLog in sp.and From next execution onwards Logging  Capture SSISDataFlowExecutionLog table.


Execute Package with Logging data capture in this table SSISDataFlowExecutionLog.


Cheers!!!!