Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2009
    Posts
    62

    Unanswered: password protect excel file using SSIS

    Hi,

    does anyone have the syntax on how to password protect an Excel file using SSIS script task? (Preferably in C#).

    thanks
    Scott

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    You can use INTEROP to do that. Check this link:
    Implementing Password Security on Excel Workbooks Using Visual Studio .NET - CodeProject

    It's not C#, but if you know C# - you'll be able to recode it.
    In C# the concept is the same, - call SaveAs method on the WorkBook object, and pass a password as a parameter.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •