none
Encrypt Excel Export from SQL Server Reporting Services prior to attaching to e-mail

    Question

  • Does SSRS 2012 have a secure e-mail Delivery Extension that would allow the Excel document to be encrypted?
    Or is there sample code?
    Or is the best approach to consider a Microsoft Partner product such as Database Potential, Inc.'s "Secure Delivery Pack for SQL Server Reporting Services"?
    http://www.databasepotential.com/product-p/sdp.htm

    Thanks in advance for any thoughts or feedback regarding this topic.

    Boyd

    Saturday, December 21, 2013 1:50 AM

Answers

All replies

  • Hi Boyd

    Reporting Services does not have a Delivery Extension that encrypts documents before sending.

    A third party solution is probably the way to go.

    The other alternative of course is to simply have the subscription write the files to a local file share. Then, using another program you encrypt the files and send them off.

    Cheers


    Josh


    Thanks! Josh

    Sunday, December 22, 2013 11:42 PM
  • Hi Boyd,

    Currently, it’s not supported a delivery extension that encrypts documents before sending them in Reporting Services. If you have the SQL Server Integration Services (SSIS) environment, you can use the following workaround:

    1. Using SSIS Script Task to encrypt the report before exporting it to the Excel file.
    2. Add a Send Mail Task to send the Excel files to the recipients.

    For the details, please refer to the document below:
    http://microsoft-ssis.blogspot.in/2011/10/encrypt-files-in-ssis.html

    In addition, we can try to use .NET API approach. In this scenario, we need capture the Excel file using the WQL Query of FileWatcher, and then encrypt the file, finally email the Excel File.

    For the details, please refer to the blog as shown below:
    http://microsoft-ssis.blogspot.in/2010/12/continuously-watching-files-with-wmi.html

    If you need more assistance, please feel free to contact me.

    Regards,
    Heidi Duan

    If you have any feedback on our support, please click here.


    Heidi Duan
    TechNet Community Support


    Monday, December 23, 2013 3:14 AM