Post reply

Lock/Password-protect excel file in SSIS pipeline

  • January 10, 2009 at 3:41 am

    #199858

    Hi Everybody,

    i am looking for a script that lets me lock an excel file right after i created it and just before i am going to send it by email to the client.

    i know excel password is a very low-level encryption but it will do the job.

    if anyone has another method to encrypt excel file it might solve this problem in a different way.

    thanks very much.

    boaz

  • December 16, 2011 at 8:37 pm

    #1422782

    This reply is a bit late, but still worth knowing. If you can use third-party solutions, check the commercial CozyRoc Excel components. These are the relevant components:

    * Excel Source component - for reading data from Excel worksheet.

    * Excel Destination component - for writing data in Excel worksheet.

    * Excel Task - for manipulating Excel workbooks.

    * Excel Connection - used by the components above and also for implementing custom scripts based on it.

    The enhanced adapters provides ability to add/remove Excel encryption password.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply