BUG: Existing Connection Combo Box in DTS UI Displays Incorrect Connections

ID: Q234031

The information in this article applies to:

Microsoft SQL Server version 7.0

BUG #: 55704 (SQLBUG_70)

SYMPTOMS

When viewing multiple local packages in the Data Transformation Services (DTS) Designer, the Existing Connection combo box displayed after clicking the Execute SQL Task icon only shows the existing connections for the first local package opened, regardless of which package is being viewed.

WORKAROUND

Choose Execute SQL Task from the Task menu option instead of using the Execute SQL Task icon.

STATUS

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

Additional query words:

Keywords : kbSQLServ700bug
Version : winnt:7.0
Platform : winnt
Issue type : kbbug