Scanning Options

DTS Designer

DTS Designer Help

Scanning Options

Use the OLE DB scanner for Microsoft® SQL Server™ 2000 Meta Data Services to import database schema information from an OLE DB data source and populate instances of the Database Information Model (DBM) in Meta Data Services. The scanner is passed an OLE DB provider, examines the schema, and creates a set of corresponding instance objects in Meta Data Services using the DBM and Data Transformation Services (DTS) Meta Data Services information models.

If you save a DTS package to Meta Data Services, you can set how the objects referenced by the package are related to SQL Server catalog meta data scanned into Meta Data Services. Meta data in this context refers to information such as:

  • Primary and foreign keys.

  • Column type, size, precision, scale, and nullability.

  • Indexes.
Options

Resolve package references to scanned catalog meta data

Enable the scanning options, which link the package to Meta Data Services meta data.

Use scanned catalogs if already present in Meta Data Services

Relate the package to Meta Data Services meta data if the meta data has already been saved (that is, by importing the meta data, or by a previous scan). This option is useful if the database schema has not changed, Meta Data Services meta data already exists, and saving time is a consideration. If column or meta data information has changed and this option is used, references of the package to Meta Data Services meta data may not be meaningful.

Scan all referenced catalogs into Meta Data Services

Scan everything about a database (all table, column, and meta data information) into Meta Data Services, even if the information is not used. This is safer than the previous option, but more costly in terms of time and performance.

Scan catalog if not already present in Meta Data Services

If a database is not present in Meta Data Services, add it. (This is the default selection if scanning options are enabled.)

Scan catalog always

Scan a database into Meta Data Services even if it is present already.

See Also

Importing and Saving Meta Data in DTS

Recording Data Lineage in DTS