Need an audit table here under where the data capture from the ssis packages when they run and I have to add the functionality to the existing packages

See more:

SSIS

CREATE TABLE [dbo].[Audit_IUD](
[ID] [int] IDENTITY(1,1) NOT NULL,
[PackageName] [varchar](100) NULL,
[TableName] [varchar](100) NULL,
[InsertRecordCount] [int] NULL,
[UpdateRecordCount] [int] NULL,
[DeleteCount] [int] NULL,
[PackageStartDateTime] [datetime] NOT NULL,
[PackageEndDateTime] [datetime] NOT NULL,
[DurationinSeconds] [int] NOT NULL)

What I have tried:

I am trying to add an execute sql task for the package beginning and ending but blocked how to declare the parameters to embedded