I have a task to run an SQL Statement, generate Result Set, encrypt it using GPG and send to user. I am using GPG4Win-3.1.15 which contains GPG 2.2.x It works fine for me BUT my goal is to get encrypted file directly from SQL query. I don't want first generate Result Set, convert it to .csv and then encrypt.
I know that using Toad one could use Toad's Automation Engine to create a work flow. It will have 2 steps
Key here is to use the Run Program task so that you can call gpg utility.
In my case I don't have Toad hence I have to use MS Studio.
Could someone advice how to do it using MS Studio?
Thanks