Sending SQL Server query as CSV via e-mail

Posted on

Question :

Currently I’m using SSIS w/ a hacky solution to get around it not supporting auth on SMTP servers.

Is there a better way I can save a query to a CSV file, then mail it as an attachment?

Thanks

Answer :

Use database mail to send the email as that supports attachments and auth on SMTP.

Leave a Reply

Your email address will not be published.