SQL Server Performance

encript dts package

Discussion in 'SQL Server DTS-Related Questions' started by cejar, Nov 26, 2003.

  1. cejar New Member

    Is there a way I can encript a DTS package?

    Cheers!
  2. FrankKalis Moderator

  3. satya Moderator

    I think its not possible, but you can encrypt the command prompt options to be executed by the DTS Run utility, allowing you to create an encrypted dtsrun command for later use.

    Refer to books online for DTSRun utility for more information.

    May I know what is the reason behind encrypt process?


    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  4. cejar New Member

    Satya, The company where Im at does not have a very secure infrastucture so Im just taking precatious measures.

    Thanks

    Cheers!
  5. satya Moderator

    Then you may refer to SQL books online about Handling Package Security in DTS topic for information on security in DTS packages.

    You can add more security by saving each DTS Package and assigning a owner password and/or a user password.



    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  6. cejar New Member

    Gracias!

    Cheers!

Share This Page