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?
Use database mail to send the email as that supports attachments and auth on SMTP.
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
3 years ago