EncryptAllWithPassword deploy package

  • Hi,

    I have developed a package in 2005 ,

    and i have set ProtectionLevel to EncryptAllWithPassword

    in order to distribute this package without code is visible and editable.

    I want protect all code that i have write in package from edit.

    But distribute and deploy it... I must provide password !!!

    So I have create another package that execute first passing password and configuration variable.

    Now if i execute on my machine all runs, if i deploy both packages on server prod

    i get error that the SSIS engine failed to decrypt the Password...

    Help me!

  • What is the protection level of the second package? I'm guessing it is EncryptSensitiveWithUserKey. This option will not work, unless you use the same account you have used to create the package on the other machine.

    What are you trying exactly to protect and in which application?

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

  • HI,

    Thanks for answer,

    My first package is an ETL that load a Data Warehouse.

    Users could access to this data by a specific application developed by me.

    This application required a activation key so

    I have write in package a "SQL task" that generate Activation key

    and i can't leave task visible and editable.

    ciao

    fede

  • What you should do in this case is to devise a way to store your package decryption password in your activation key. Just keep in mind this might not be so hard to break, but I think it will safe enough for your user base and needs.

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

  • I want protect know how of entire package.

    Activation key is one of information that i want to proptect

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

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