Dts.Events.FireInformation - Is there a way to get this to log?

• Pete Bishop

  Default port

  Points: 1493

  More actions

  November 4, 2025 at 11:35 pm

  #4681024

  Using FireInformation is useful when running interactively as the messages appear in the Progress window. However, when deployed to an SSIS catalog and executed from an Agent job, these messages don't appear in SSISDB.catalog.operation_messages - even if the logging level is set to Verbose.

  Is there a way to get these messages to log in the SSISDB database for later retrieval? If not, is there another method that can be used from within a C# Script Task?

  Many thanks.

• frederico_fonseca

  SSCoach

  Points: 16279

  More actions

  November 5, 2025 at 9:55 am

  #4681153

  they are within the catalog for sure as I use it as well.

  but I also change the default cleanup settings and server lvl logging

• Tim Mitchell

  SSCoach

  Points: 15696

  More actions

  November 6, 2025 at 10:20 pm

  #4681876

  Try the catalog.event_messages view in the SSIS catalog. Anything originating from FireInfo or FireError will be visible there.

  Tim Mitchell
  TimMitchell.net | @tmitch.net | Tyleris.com
  ETL Best Practices