Editing a DTS Package

When you edit a Data Transformation Services (DTS) package, you modify or further customize a previously saved package. For example, you can create a package that copies data from an Oracle server to an instance of Microsoft® SQL Server™ 2000, and later you can add a task that sends an e-mail notification when the copy operation completes.

You edit a package by:

• Using DTS Designer.

  Note  You cannot use the DTS Import/Export Wizard to edit a package.

• Using the Microsoft Visual Basic® development environment, if a package has been created with DTS Designer or the DTS Import/Export Wizard and saved as a Visual Basic file.
  
  
• Using the Microsoft Visual Studio® development environment, if a package has been created in Microsoft Visual Basic or Microsoft Visual C++® modules and saved as a Visual Basic or Visual C++ project. In most cases, you can open these types of packages for editing in DTS Designer after saving them.

To edit a package, you must have authorization to open the package. If a package is saved with an owner password and you do not have access to that password, you cannot edit the package. If a user password is set, and you have access to that password, you can execute but not edit the package.

You cannot set DTS package password protection if you save a package to SQL Server 2000 Meta Data Services. In that case, you need to handle security through Windows Authentication or SQL Server Authentication. For more information, see Handling Package Security in DTS.

To edit a DTS package saved to a structured storage file

Enterprise Manager

To edit a DTS package saved to SQL Server or Meta Data Services

Enterprise Manager