PRB: DTS Diagram Changes When DTS Package is Opened and Saved Outside the Package Designer (249901)
The information in this article applies to:
- Microsoft SQL Server 7.0
- Microsoft SQL Server 2000 (all editions)
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:
- The package is opened programmatically outside the DTS Package Designer. For example, using Visual Basic or Visual C++.
- The package is then saved with or without any changes.
- 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.
| Modification Type: | Major | Last Reviewed: | 10/31/2003 |
|---|
| Keywords: | kbprb KB249901 |
|---|
|