Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 DTS package run using a BATCH FILE. HIDE PASSWORD

Author  Topic 

ashley.sql
Constraint Violating Yak Guru

299 Posts

Posted - 2007-06-28 : 13:58:07
I have a batch file which uses the DTSRUN utility.

dtsrun /Sservername /Uusername /Ppassword /Ndtspackagename


I have to give this file to the users to run it at the end of day oepration but need a way to hide the password. Thats the requirement.

Is there a way to do this. I tried to zip the file and then open the compressed folder with notepad and save it as Batch file. But that is not executable file.

Is there any other way to hide the password or encrypt the password.
I am not allowed to download any third party tools. :(

Ashley Rhodes

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-28 : 23:41:03
Possible to use windows authentication?
Go to Top of Page
   

- Advertisement -