This is not as easy as it looks.

SSIS Approach:

As usual export the report as excel file --> Using SSIS Script Task(Excel COM Components) encrypt the file --> Email the file(using the Send Email Task)

.NET API Approach:

Capture the Excel file using the WQL Query of FileWatcher-->Encrypt the file-->Email the File