Suppressing DBCC Messages

• mikegreen

  Valued Member

  Points: 67

  More actions

  March 22, 2002 at 2:57 pm

  #357505

  I need to run a DBCC command in my DTS package and it data transforms to an Excel file. Problem is I get the invalid pointer error when it runs because it gives the completion message. NOCOUNT is on.

  Thoughts?

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  March 22, 2002 at 3:40 pm

  #425953

  Try using 'with NO_INFOMSGS'. Not sure if all DBCC supports it or not.

  Andy

  Andy
  Connect with me on LinkedIn