Export (0) Print
Expand All

Saving a DTS Package to a Structured Storage File

SQL Server 2000

Save a Data Transformation Services (DTS) package to a structured storage file if you want to copy, move, and send a package across the network without having to store the package in a Microsoft® SQL Server™ database.

With the structured storage format, you can maintain multiple packages and multiple package versions in a single file. If you want to save multiple packages to the same structured storage file, use different package names but the same file name when saving. However, every package and package version you save under the structured storage file name persists for the lifetime of that file. Although you can edit individual packages or package versions saved to a structured storage file, you cannot delete them. Therefore, you need to manage package versions differently when saving to structured storage files than when saving to SQL Server.

When saving a package to SQL Server, you can delete any package version you want. With a structured storage file, you can delete only the entire file. If you want to retain or branch a specific package version saved in a structured storage file, save the package version under a new file name. It is recommended that you do this infrequently, because saving multiple packages with multiple versions can generate a sizeable number of large files.

Note  When you save a DTS package to a structured storage file, you create a file with the extension .dts.

To save a DTS package to a structured storage file

Enterprise Manager

To open a DTS package saved to a structured storage file

Enterprise Manager

See Also

Recording Data Lineage in DTS

Show:
© 2015 Microsoft