SSIS Catalog

E307900

SQL Server feature SSIS management framework centralized SSIS repository

SSIS Catalog is a centralized SQL Server repository and management framework for deploying, storing, configuring, and monitoring SQL Server Integration Services (SSIS) projects and packages.

Try in SPARQL Jump to: Surface forms Disambiguation Statements Elicitation Referenced by

All labels observed (3)

Label	Occurrences
SSIS Catalog canonical	1
SSISDB	1
SSISDB database	1

How this entity was disambiguated

This entity first appeared as the object of triple T2880509 — resolving that mention is where its identity was fixed. The disambiguator weighed these candidate entities and picked the highlighted one (or “None”, minting a new entity). This is how homonymy is resolved: the same surface form can point to different entities.

NED1 Entity disambiguation (via context triple) gpt-5-mini-2025-08-07

Target entity: SSIS Catalog
Context triple: [SQL Server Integration Services, hasComponent, SSIS Catalog]

A. SQL Server Integration Services
SQL Server Integration Services is a Microsoft ETL and data integration platform used to extract, transform, and load data between diverse sources within the SQL Server ecosystem.
B. SQL Server Management Data Warehouse
SQL Server Management Data Warehouse is a SQL Server feature that collects, stores, and reports performance and configuration data from managed servers to support monitoring and analysis.
C. SQL Server Analysis Services
SQL Server Analysis Services is a Microsoft server-based data analysis and business intelligence platform used to create and manage OLAP cubes and data mining models for advanced analytics and reporting.
D. SQL Server Agent
SQL Server Agent is a Microsoft SQL Server component that automates administrative tasks such as job scheduling, alerting, and routine maintenance operations.
E. SQL Server Analysis Services Tabular
SQL Server Analysis Services Tabular is a Microsoft in-memory analytical engine for building tabular data models that support fast, interactive business intelligence and reporting.
F. None of above. chosen
G. Unsure - the case is ambiguous/there is not enough information to decide.

NED2 Entity disambiguation (via description) gpt-5-mini-2025-08-07

Target entity: SSIS Catalog
Target entity description: SSIS Catalog is a centralized SQL Server repository and management framework for deploying, storing, configuring, and monitoring SQL Server Integration Services (SSIS) projects and packages.

A. SQL Server Integration Services
SQL Server Integration Services is a Microsoft ETL and data integration platform used to extract, transform, and load data between diverse sources within the SQL Server ecosystem.
B. SQL Server Management Data Warehouse
SQL Server Management Data Warehouse is a SQL Server feature that collects, stores, and reports performance and configuration data from managed servers to support monitoring and analysis.
C. SQL Server Analysis Services
SQL Server Analysis Services is a Microsoft server-based data analysis and business intelligence platform used to create and manage OLAP cubes and data mining models for advanced analytics and reporting.
D. SQL Server Agent
SQL Server Agent is a Microsoft SQL Server component that automates administrative tasks such as job scheduling, alerting, and routine maintenance operations.
E. SQL Server Analysis Services Tabular
SQL Server Analysis Services Tabular is a Microsoft in-memory analytical engine for building tabular data models that support fast, interactive business intelligence and reporting.
F. None of above. chosen

Statements (52)

Predicate	Object
instanceOf	SQL Server feature ⓘ SSIS management framework ⓘ centralized SSIS repository ⓘ
allows	manual execution of SSIS packages ⓘ scheduling via SQL Server Agent jobs ⓘ
captures	data statistics for executions ⓘ event logs ⓘ execution messages ⓘ
createdBy	SSISDB creation wizard ⓘ
defaultDatabaseName	SSIS Catalog self-linksurface differs ⓘ surface form: SSISDB
developedBy	Microsoft ⓘ
exposedAs	SSIS Catalog self-linksurface differs ⓘ surface form: SSISDB database
integratesWith	SQL Server Management Studio ⓘ
introducedInVersion	SQL Server ⓘ surface form: SQL Server 2012
monitors	execution performance counters ⓘ package execution status ⓘ
provides	built-in SSIS reports ⓘ centralized configuration ⓘ centralized deployment ⓘ centralized execution ⓘ centralized monitoring ⓘ logging of SSIS executions ⓘ rollback to previous project versions ⓘ versioning of deployed projects ⓘ
replaced	MSDB deployment model for SSIS ⓘ file system deployment model for SSIS ⓘ
requires	CLR integration enabled ⓘ SQL Server Agent for scheduling executions ⓘ SQL Server Integration Services feature ⓘ
runsOn	SQL Server ⓘ surface form: Microsoft SQL Server
schemaName	catalog ⓘ
securedBy	SQLAgentUserRole ⓘ surface form: SQL Server database roles SQL Server permissions ⓘ
stores	SSIS environment variables ⓘ SSIS environments ⓘ SSIS packages ⓘ SSIS projects ⓘ package parameters ⓘ project parameters ⓘ
supports	encryption of sensitive data ⓘ environment references ⓘ environment-level security ⓘ folder-level security ⓘ package-level configurations ⓘ parameter binding to environment variables ⓘ project deployment model ⓘ project-level configurations ⓘ project-level security ⓘ
uses	catalog stored procedures ⓘ catalog views ⓘ database master key for encryption ⓘ internal SSISDB schema ⓘ

How these facts were elicited

Referenced by (3)

Full triples — surface form annotated when it differs from this entity's canonical label.

SQL Server Integration Services → hasComponent → SSIS Catalog ⓘ

SSIS Catalog → exposedAs → SSIS Catalog self-linksurface differs ⓘ

this entity surface form: SSISDB database

SSIS Catalog → defaultDatabaseName → SSIS Catalog self-linksurface differs ⓘ

this entity surface form: SSISDB

All labels observed (3)

How this entity was disambiguated Show

Statements (52)

How these facts were elicited Show

Referenced by (3)

How this entity was disambiguated

How these facts were elicited