DTSRepositoryMetadataOptions

DTS Programming

DTS Programming

DTSRepositoryMetadataOptions

The DTSRepositoryMetadataOptions constants specify scanning and resolution options to use when storing a Data Transformation Services (DTS) package to Microsoft® SQL Server™ 2000 Meta Data Services.

Constant Value Description
DTSReposMetadata_Default 0 Package performs no scanner resolution.
DTSReposMetadata_RequireScannedCatalog 1 Package requires that any database objects must have been scanned into Meta Data Services.
DTSReposMetadata_ScanCatalogAlways 8 Package will scan all catalogs referenced, rescanning if already scanned.
DTSReposMetadata_ScanCatalogIfNotFound 4 Package will issue a scan on all catalogs that are not found already scanned.
DTSReposMetadata_UseScannedCatalogIfPresent 2 Package will use any scanned objects found; nonscanned references will create local objects.

See Also

RepositoryMetadataOptions Property