Reporting services for pulling, encrypting, and emailing data? RRS feed

  • Question

  • I would like to automate some recurring data pulls from my database.  My IT department doesn't have the bandwidth to build a solution and has offered Microsoft Reporting Services as an option.  I've never used it before and was hoping to better understand its capabilities.

    Specifically I'll need it to do the following:

    1.  Run a stored procedure on a weekly basis
    2.  Extract the results of that stored procedure in some excel-friendly format (csv, xls, etc)
    3.  Encrypt extracted data using a pre-defined pgp key
    4.  Email the data to some recipient set

    (The point here is that the data must be encrypted prior to being delivered in email)

    Can you tell me if MS Reporting Services a viable option?

    Monday, January 12, 2009 5:20 PM