To extract metadata and to configure other capabilities that a catalog source might include, you need account access and permissions on the source system. The permissions required might vary depending on the capability.
Permissions to extract metadata
Ensure that you have the required permissions to enable metadata extraction.
To extract the SSIS project files from an SSISDB database in the SSISDB mode, grant permissions to perform the following operations on the SSISDB database:
•select on catalog.folders
•select on catalog.projects
•select on catalog.packages
•select on catalog.environments
•select on catalog.environment_variables
•select on catalog.object_parameters
•execute on catalog.get_project procedure
To read specific folders, projects, or packages, assign one of the following roles or permissions: