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

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:

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.

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:

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