Delete From sysssislog?

• Colin Betteley

  Hall of Fame

  Points: 3095

  More actions

  July 23, 2012 at 4:43 am

  #261509

  Hi, I have a lot of entries in sysssislog and want to clear out the old ones. Is it O.K. to do a simple DELETE FROM query? I know that sometimes it is best to use microsoft commands to edit msdb tables, in order to clear tables in an elegant way; but I cannot find anything useful on the subject.

  Thanks. Colin

• Ant-Green

  SSC Guru

  Points: 113504

  More actions

  July 23, 2012 at 5:27 am

  #1516143

  I've only found one topic on this, but it said it is OK to delete from sysssislog manually

  http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/ef333ad4-d370-4cea-8055-227d402ba65b

• Colin Betteley

  Hall of Fame

  Points: 3095

  More actions

  July 23, 2012 at 6:42 am

  #1516194

  Thanks. That was the link I found. Guess I was looking for a "second opinion", just to be on the safe side. 🙂

  Colin

• laksgovi

  SSC Rookie

  Points: 37

  More actions

  June 27, 2018 at 7:10 pm

  #1995540

  Colin Betteley - Monday, July 23, 2012 6:42 AM

  Thanks. That was the link I found. Guess I was looking for a "second opinion", just to be on the safe side. :-)Colin

  Were you fairly succesful?