Microsoft KB Archive/249901

= PRB: DTS Diagram Changes When DTS Package is Opened and Saved Outside the Package Designer =

Article ID: 249901

Article Last Modified on 10/31/2003

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q249901



SYMPTOMS
A Data Transformation Services (DTS) package may lose its screen layout as seen in the DTS Package Designer inside SQL Enterprise Manager if:
 * 1) The package is opened programmatically outside the DTS Package Designer. For example, using Visual Basic or Visual C++.
 * 2) The package is then saved with or without any changes.
 * 3) The package is then reopened in the DTS Package Designer.



CAUSE
This behavior is by design.



WORKAROUND
If no changes to the DTS Package itself are intended, a copy of the package can be made and opened programmatically.

Keywords: kbprb KB249901

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.