How to over-ride the existing event logging options during run-time

• aveerabadran

  Ten Centuries

  Points: 1271

  More actions

  July 9, 2012 at 4:12 am

  #263968

  Hi,

  In SSIS, i know how to enable/disable event logging like 'On-Error','On post execute' during package development time.

  But, I have a requirement where i should be able to over-ride the existing event logging options (based on my requirement) during run-time. Do we have any option in DTEXEC utility to over-ride this? or Do we have any other way?

  I am using SQLServer 2008 R2 Developer edition.

  Appreciate your help.

  Thanks,

  Arun

• alpeshchauhan

  SSC Enthusiast

  Points: 149

  More actions

  July 10, 2012 at 10:45 pm

  #1511317

  sql server 2008 better than sql server 2003

• Rock from VbCity

  Hall of Fame

  Points: 3991

  More actions

  July 10, 2012 at 11:06 pm

  #1511321

  Hi aveerabadran

  Please take a look at this blog: How do I disable all logging on my packages?

  Cheers,

  Hope this helps,
  Rock from VbCity