Article ID: 249901 - Last Review: October 31, 2003 - Revision: 3.2

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

View products that this article applies to.
System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.
This article was previously published under Q249901
Expand all | Collapse all

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.
Back to the top

CAUSE

This behavior is by design.
Back to the top

WORKAROUND

If no changes to the DTS Package itself are intended, a copy of the package can be made and opened programmatically.
Back to the top
APPLIES TO
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Standard Edition
Back to the top
Keywords: 
kbprb KB249901
Back to the top