Before you create an SQL Server Integration Services resource, you must configure the metadata source. If you do not correctly configure the metadata source, the metadata load can fail or the metadata can be incorrectly loaded in the Metadata Manager warehouse.
To configure SQL Server Integration Services, perform the following tasks:
Install the Metadata Manager Agent, if required.
To extract metadata from packages in the repository, verify that the Microsoft SQL Server Database Engine is running.