Logging over Project Deployment Model

While in the Legacy Deployment Model approach the logging data was recorded in the Sysssislog table, in this new model approach all logging data is stored in tables under a new database created exclusively for this approach and named SSISDB. This database supports the SSIS catalog, which is the central storage and administration point for Integration Services projects, packages, parameters, and environments.

This means that data is centralized, more complete, and anyone (with the respective permissions to the SISDB database) has the ability to build their own custom reports based on the log data. The SSIS catalog provides four different log levels—Basic (default log level), None, Performance, and Verbose.

• None level— Captures enough generic information to inform whether the package succeeded or failed and other generic information.

• Basic level— Captures the same generic information as None level and all SSIS event types except the OnProgress and OnCustomEvent...