Dynamically control logging

• mike wilson-201866

  SSC Enthusiast

  Points: 180

  More actions

  October 23, 2008 at 7:41 am

  #195053

  I'd like to be able to control how much information is logged to SQL Server from my SSIS package.

  When things are going good I'd like just the minimum, when they are going bad I'd like more.

  I'd like to change this via a DB entrty

  The reason why is I can easily change a DB entry in Production than I can elevate a new SSIS package with more verbose logging turned on.

  Why don't I want it on all the time? Too many entries and the table is filling up.

  Ideas?

  Thanks

• VG-619426

  Hall of Fame

  Points: 3914

  More actions

  October 23, 2008 at 4:20 pm

  #888936

  My Suggestion would be to select only OnError event. So, only if error happens, it get logged..

  VG