Export (0) Print
Expand All
Expand Minimize

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

SQL Server 2000

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

Show:
© 2015 Microsoft