Execution Patterns - SQL Server Integration Services Design Patterns - page 93

Figure 2-10 . A representation of the SSIS Catalog
Integration Services is contained by a server and, in turn, it contains a catalog. In
SQL Server 2014, Integration Services contains a single catalog named SSISDB.
SSISDB is also the name of the database used to manage SSIS metadata in the catalog.
A catalog contains one or more folders. Folders contain one or more projects, which
contain one or more packages.
In the btnStartCatalogClick subroutine, the code declares variables for the
objects in this hierarchy (using Dim statements) and sets their value based on the
names supplied in the five text boxes: txtSSISCatalogServer, txtCatalog, txtFolder, tx-
tCatalogProject, and txtCatalogPackage. As you can see by comparing the names of the
text boxes to Figure 2-10 , an SSIS package stored in the catalog can be uniquely identi-
fied using this hierarchy. How are the text boxes populated? The user can enter the in-
formation manually if desired. But the application contains a second form, launched by
the ellipsis in the SSIS Package in the Catalog group box, to facilitate SSIS catalog
navigation.