Packages
The fundamental element of a DTS application is the package. You can create a package in one of two ways: via the DTS Import/Export Wizard or the DTS Designer. A package can be stored in SQL Server, in the Metadata Repository, as Visual Basic code (this is a one-way operation—you cannot load packages saved as VB into the DTS Designer), or in a COM structured storage file.
NOTE: As of this writing, if you want to enable the ability to save packages to the repository, you must right-click the Data Transformation Services node in Enterprise Manager, select the Properties option, and check the Enable Save To Meta Data Services checkbox. Until this option is enabled, Meta Data Services will not appear as an option in the package save dialog ...
Get Guru's Guide to SQL Server Architecture and Internals, The now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
