Is it possible to send the output of DBCC CHECKDB by email in SSIS?

• virgilrucsandescu

  SSCrazy

  Points: 2457

  More actions

  July 17, 2010 at 7:02 pm

  #148085

  I am curious if the output of a dbcc checkdb query can be sent by email with the regular "send email task" in ssis? (I mean just ssis, without the help of SQL Server Agent and sending its output to a file)?

• PaVeRa22

  SSCommitted

  Points: 1965

  More actions

  July 17, 2010 at 9:23 pm

  #1194601

  you can send output via send mail task, howerver you need to create output of that command to a file, attach file in mail task as attachment.

  without attachment, i guess no, we cant send output directly.

  how will you run your package without agent? ( any other invoking methods you use)