BUG: Security Information Not Persistent for the Connection Object in a DTS Package

ID: Q244943

The information in this article applies to:

Microsoft SQL Server version 7.0

BUG #: 56660 (SQLBUG_70)

SYMPTOMS

After creating a Data Transformation Services (DTS) Package, the security credentials are not persistent for a connection object in the DTS package.

WORKAROUND

Edit the connection object and click the Advanced button. Next, change the value of the Persist Security Info to 1. This ensures that the security credentials are saved or persistent.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0.

Additional query words: DTS Persistent connection password package object save saved information sql server 7.0

Keywords : kbbug7.00 kbSQLServ700bug
Version : winnt:7.0
Platform : winnt
Issue type : kbbug