Skip to content

Latest commit

 

History

History
63 lines (43 loc) · 3.41 KB

view-package-objects.md

File metadata and controls

63 lines (43 loc) · 3.41 KB
Raw
title description author ms.author ms.date ms.service ms.subservice ms.topic helpviewer_keywords
View Package Objects
View Package Objects
chugugrace
chugu
03/02/2017
sql
integration-services
conceptual
Integration Services packages, properties
properties [Integration Services]
Package Explorer window [Integration Services]
packages [Integration Services], properties
explorer view [Integration Services]
SSIS packages, properties
viewing package objects
SQL Server Integration Services packages, properties

View Package Objects

[!INCLUDEsqlserver-ssis]

In [!INCLUDEssIS] Designer, the Package Explorer tab provides an explorer view of the package. The view reflects the container hierarchy of the [!INCLUDEssISnoversion] 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. [!INCLUDEssISnoversion] 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

View the package structure and content

  1. In [!INCLUDEssBIDevStudioFull], open the [!INCLUDEssISnoversion] 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.

View the properties of a package object

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

Delete an object in a package

  • Right-click an object and then click Delete.

See Also

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