I was tasked to automate an encryption of a data extraction output. It's basically a query to a SQL table and saved as a .csv file. Then I want to be able to use GNU Privacy Guard and encrypt the file.
Is there anyway to automate this process? I was maybe SSIS and then use xp_sendmail (Transact-SQL)
to send the email with the file attached.