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
Raunak J