Export (0) Print
Expand All

Saving a DTS Package to SQL Server

SQL Server 2000

Save your Data Transformation Services (DTS) package to Microsoft® SQL Server™ if you want to store packages on any instance of SQL Server on your network, keep a convenient inventory of those packages, and add and delete package versions during the package development process. This option saves a DTS package in the sysdtspackages table in the SQL Server msdb database as BLOB (binary large object) data.

You can save and delete versions of a SQL Server package. If a package has multiple versions, you can display a version history in SQL Server Enterprise Manager and open the version you want. Otherwise, the latest package version is opened.

To save a DTS package to SQL Server

Enterprise Manager

To access a DTS package saved to SQL Server

Enterprise Manager

© 2014 Microsoft