Home Forums Data Warehousing Integration Services Export SSRS Report to Password Protected Excel File RE: Export SSRS Report to Password Protected Excel File

  • October 10, 2010 at 10:31 pm

    #1234771

    Well, SSIS does use the Jet driver, via OpenRowSet, to work with Excel files. So, this link will probably help you out. You would just need to add it to the extended properties of the Excel Configuration in the properties window.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2