How to modify the persisting of authentication information (Enterprise Manager)

How to modify the persisting of authentication information (Enterprise Manager)

To modify the persisting of authentication information in a DTS package

1. On the Data Transformation Services (DTS) Designer design sheet, double-click a connection.
   
   
2. In the Connection Properties dialog box, click Advanced.
   
   
3. Under the Value column, click the value for the Persist Security Info property.
   
   
4. Do one of the following:
   • Type 0 to disable the saving of authentication information with the DTS package.
     
     
   • Type 1 to persist the saving of authentication information.

See Also

Handling Package Security in DTS