View Package Objects

 

In SSIS Designer, the Package Explorer tab provides an explorer view of the package. The view reflects the container hierarchy of the Integration Services architecture. The package container is at the top of the hierarchy, and you expand the package to view the connections, executables, event handlers, log providers, precedence constraints, and variables in the package.

The executables, which are the containers and tasks in the package, can include event handlers, precedence constraints, and variables. Integration Services supports a nested hierarchy of containers, and the For Loop, Foreach Loop, and Sequence containers can include other executables.

If a package includes a data flow, the Package Explorer lists the Data Flow task and includes a Components folder that lists the data flow components.

From the Package Explorer tab, you can delete objects in a package and access the Properties window to view object properties.

The following diagram shows a tree view of a simple package.

Screenshot of the Package Explorer tab

  1. In SQL Server Data Tools (SSDT), open the Integration Services project that contains the package you want to view in Package Explorer.

  2. Click the Package Explorer tab.

  3. To view the contents of the Variables, Precedence Constraints, Event Handlers, Connection Managers, Log Providers, or Executables folders, expand each folder.

  4. Depending on the package structure, expand any next-level folders.

  • Right-click an object and then click Properties to open the Properties window.
  • Right-click an object and then click Delete.

Integration Services Tasks
Integration Services Containers
Precedence Constraints
Integration Services (SSIS) Variables
Integration Services (SSIS) Event Handlers
Integration Services (SSIS) Logging

Community Additions

ADD
Show: