Importing and Saving Meta Data in DTS
You can import meta data to Microsoft® SQL Server™ 2000 Meta Data Services through SQL Server Enterprise Manager or by using the Data Transformation Services (DTS) scanning options. When you import meta data using SQL Server Enterprise Manager, you read the meta data from only one database. You can read the meta data from all referenced databases in a package by selecting the Scan all referenced catalogs check box in the Scanning Options dialog box.
Note For the import of meta data to work, the data provider specified must support OLE DB schema rowsets.
The OLE DB scanner for Meta Data Services is a utility that imports database schema from an OLE DB data source. The scanner is passed an OLE DB provider, examines the schema, and creates a set of corresponding instance objects in Meta Data Services.
If you save package information to Meta Data Services, you can save meta data about the databases referenced in the package, such as:
- Primary and foreign keys.
- Column type, size, precision, scale, and nullability information.
- Indexes.
You can view meta data information saved to Meta Data Services through the DTS Browser. For more information, see Viewing Meta Data in DTS.