How to set a DTS package password (Enterprise Manager)

To set a DTS package password in DTS Designer

1. On the Package menu, click Save or Save As.
   
   
2. In the Location list, click either SQL Server or Structured Storage File.
   
   
3. Do one of the following:
   • Enter an Owner password. Assigning an Owner password puts limits on who can both edit and run the package.
     
     
   • Enter a User password. Assigning a User password puts limits only on who can edit the package. If you create a User password, you must also create an Owner password.

See Also

Handling Package Security in DTS