Microsoft KB Archive/286268

= FIX: User and Owner Passwords are Dimmed When You Save a Package as a File By Using DTSWIZ =

Article ID: 286268

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q286268



BUG #: 236124 (SHILOH_BUGS)



SYMPTOMS
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.



RESOLUTION
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:

290211 INF: HOw to Obtain the Latest SQL Server 2000 Service Pack



WORKAROUND
To work around this problem, use any of the methods that follow:
 * If you want to save packages as files with user and owner passwords, you can use the DTS Designer to save the packages.
 * If you already have packages stored as files without passwords, reopen the packages in the DTS Designer and click Save As under Package to save them with the passwords.
 * You can provide additional security for the packages that are saved as files by restricting the Microsoft Windows NT level permissions to the folder where the packages are saved.



STATUS
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.



MORE INFORMATION
In SQL Server 2000, you can save DTS packages:
 * To a local or remote SQL Server server (stored in the msdb..sysdtspackages table).
 * To the repository.
 * As a structured storage file (saved as a .dts file).
 * As a Visual Basic file (saved as a .bas file).

The owner and password options are available when the package is saved to SQL Server or as a structured storage file.

Additional query words: dimmed greyed grayed unavailable

Keywords: kbbug kbfix kbsqlserv2000sp1fix KB286268

-

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

© Microsoft Corporation. All rights reserved.