• As to collecting Package/TaskID, Name pair info. I am working on something that everyone can use, if not I will have to address individual needs.

    Below is the audit log table structure

    CREATE TABLE [sysssislog]

    (

    [id] [INT] NOT NULL IDENTITY PRIMARY KEY,

    [event] [SYSNAME] NOT NULL,

    [computer] [NVARCHAR] (128) NOT NULL,

    [operator] [NVARCHAR] (128) NOT NULL,

    [source] [NVARCHAR] (1024) NOT NULL,

    [sourceid] [UNIQUEIDENTIFIER] NOT NULL,

    [executionid] [UNIQUEIDENTIFIER] NOT NULL,

    [starttime] [DATETIME] NOT NULL,

    [endtime] [DATETIME] NOT NULL,

    [datacode] [INT] NOT NULL,

    [databytes] [IMAGE] NULL,

    [message] [NVARCHAR] (2048) NOT NULL,

    )

    ON [PRIMARY]

    after that you can for instance check out Stan Kulp's article on this website "An Introduction to Integration Services log providers" for how to enable logging into the table.

    Frank Banin
    BI and Advanced Analytics Professional.