Article ID: 286268 - View products that this article applies to.
This article was previously published under Q286268
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 236124 (SHILOH_BUGS)
You can save Data Transformation Services (DTS) packages with an owner and user password for additional security except when you save them to the repository or to a Microsoft Visual Basic file. However, when you try to save a DTS package as a structured storage file by using the DTSWIZ (DTS wizard), the options to specify an owner and user password appear dimmed.
This problem only occurs when you try to save the package as a structured storage file by using DTSWIZ.
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/290211/EN-US/ )INF: HOw to Obtain the Latest SQL Server 2000 Service Pack
To work around this problem, use any of the methods that follow:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was first corrected in Microsoft SQL Server 2000 Service Pack 1.
In SQL Server 2000, you can save DTS packages: