You can use the Metadata Manager Agent installed on any machine.

Enter a value in this property when you create a resource that extracts metadata from multiple package files or if the package file has dependent connection manager (.conmgr) files. To extract metadata from one package file that does not have dependent connection manager files, enter the file name and file path in the

File

property instead.

If you enable this option, Metadata Manager loads metadata from the package file in the location you specify. The path to the file must include an absolute path that is accessible from the Metadata Manager Agent machine.

If you disable this option, Metadata Manager copies the package file to the Metadata Manager application directory when you finish configuring the resource. Metadata Manager loads metadata from the package file in the Metadata Manager application directory.

If you specify a source directory in the

Directory

property, this property is ignored. Metadata Manager loads metadata from the package files in the directory you specify.

File that defines the values for the user-defined variables in the package. Specify a variable values file when variables in the package do not have values or when you want to override the variable values defined in the package.

The location of the variable values file must be accessible from the machine where the Metadata Manager Service runs. When SQL Server Integration Services is not on the same machine as the Metadata Manager Service, ensure that the variable values file is in a location that both SQL Server Integration Services and the Metadata Manager Service can access.

If the package does not contain an Execute SQL task with a file source, Metadata Manager ignores this property.

Required if the package is encrypted with a password. If you do not enter the password, the Metadata Manager Agent cannot extract metadata from the package.

Optional if the values of sensitive properties in the package are encrypted with a password. Metadata is not a sensitive property. Therefore, the Metadata Manager Agent can extract metadata whether or not you specify the password.

Controls how Metadata Manager displays lineage for Script components that are used as transformations.

If you set this property to true, Metadata Manager does not display input or output ports for any transformation script. The data lineage diagram shows links between all columns in the source object and all columns in the target object.

If you set this property to false, Metadata Manager creates a separate object in the lineage diagram for each transformation script.

Default is true.

Metadata Manager configures connection assignments to relational database resource types during the resource load. If you disable this option, configure connection assignments in the resource properties after you create the resource.

Enter a value in this property when you create a resource that extracts metadata from one package file that does not have dependent connection manager (.conmgr) files. To extract metadata from multiple package files or from a file that has dependent connection manager files, enter the file path in the

Directory

property instead.