Table of Contents

Search

  1. Preface
  2. Using Metadata Manager
  3. Configuring Metadata Manager
  4. Application Resources
  5. Business Glossary Resources
  6. Business Intelligence Resources
  7. Custom Resources
  8. Data Integration Resources
  9. Data Modeling Resources
  10. Database Management Resources
  11. Universal Resources
  12. Managing Resources
  13. Loading and Monitoring Resources
  14. Managing Permissions
  15. Resource Migration
  16. Repository Migration
  17. Appendix A: Metadata Manager Login
  18. Appendix B: Metadata Manager Properties Files
  19. Appendix C: Resource Configuration Files
  20. Appendix D: Glossary

Metadata Manager Administrator Guide

Metadata Manager Administrator Guide

SQL Server Integration Services File Configuration Properties

SQL Server Integration Services File Configuration Properties

Update the configuration properties when you create or edit an SQL Server Integration Services resource that is based on one or more package files.
The following table describes the configuration properties:
Property
Description
Agent URL
Host name and port number of the Metadata Manager Agent.
You can use the Metadata Manager Agent installed on any machine.
Source system version
Name and version of the metadata source. Select
Microsoft SQL Server Integration Services (File)
.
Directory
Directory that contains the package (.dtsx) files from which you want to extract metadata.
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.
All dependent external connection manager files with the .conmgr extension must be in the same directory as the package files.
Always use latest source files
If you specify a source file in the
File
configuration property, this property controls whether Metadata Manager uses the package file in the location you specify or copies the package file to the Metadata Manager application directory.
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.
Variable values file
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.
Encoding
Code page for Execute SQL task source files. Default is Western European (Windows-1252).
If the package does not contain an Execute SQL task with a file source, Metadata Manager ignores this property.
Password
Password for the package.
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.
Hide transformation scripts
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.
Auto assign connections
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.
File
File path and file name for the package (.dtsx) file.
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.

0 COMMENTS

We’d like to hear from you!