SQL Server Performance Forum – Threads Archive
encript dts package
Is there a way I can encript a DTS package? Cheers!I don’t know much about DTS, but for the questions I had I always found an answer onhttp://www.sqldts.com Frank
http://www.insidesql.de
http://www.familienzirkus.de
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
Satya, The company where Im at does not have a very secure infrastucture so Im just taking precatious measures. Thanks Cheers!
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
Gracias! Cheers!
]]>