Export (0) Print
Expand All

Integration Services User Interface

In addition to the design surfaces on the SSIS Designer tabs, the user interface provides access to the following windows and dialog boxes for adding features to packages and configuring the properties of package objects:

  • The dialog boxes and windows that you use to add functionality such as logging and configurations to packages.
  • The custom editors for configuring the properties of package objects. Almost every type of container, task, and data flow component has its own custom editor.
  • The Advanced Editor dialog box, a generic editor that provides more detailed configuration options for many data flow components.

Business Intelligence Development Studio also provides windows and dialog boxes for configuring the environment and working with packages.

After you open a package or create a new package in SSIS Designer, the following dialog boxes and windows are available.

This table lists the dialog boxes that are available from the SSIS menu and the design surfaces of SSIS Designer.

Dialog box Purpose Access

Configure SSIS Logs

Configure logging for a package and its tasks by adding logs and setting logging details.

On the SSIS menu, click Logging.

-or-

Right-click anywhere on the design surface of the Control Flow tab, and then click Logging.

Package Configuration Organizer

Add and edit package configurations. You run the Package Configuration Wizard from this dialog box.

On the SSIS menu, click Package Configurations.

-or-

Right-click anywhere on the design surface of the Control Flow tab, and then click Package Configurations.

Digital Signing

Sign a package or remove the signature from the package.

On the SSIS menu, click Digital Signing.

-or-

Right-click anywhere on the design surface of the Control Flow tab, and then click Digital Signing.

Set Breakpoints

Enable breakpoints on tasks and set breakpoint properties.

On the design surface of the Control Flow tab, right-click a task or container, and then click Edit Breakpoints. To set a breakpoint on the package, right-click anywhere on the design surface of the Control Flow tab, and then click Edit Breakpoints.

This table lists the windows that are available from the SSIS and View menus and the design surfaces of SSIS Designer.

Window Purpose Access

Variables

Add and manage custom variables.

On the SSIS menu, click Variables.

-or-

Right-click anywhere in the design surface of the Control Flow and Data Flow tabs, and then click Variables.

-or-

On the View menu, point to Other Windows, and then click Variables.

Log Events

View log entries at run time.

On the SSIS menu, click Log Events.

-or-

Right-click anywhere in the design surface of the Control Flow and Data Flow tabs, and then click Log Events.

-or-

On the View menu, point to Other Windows, and then click Log Events.

Integration Services provides a custom dialog box for most containers, tasks, sources, transformations, and destinations.

The following table describes how to access custom dialog boxes.

Editor type Access

Container. For more information, see Integration Services Containers.

On the design surface of the Control Flow tab, double-click the container.

Task. For more information, see Integration Services Tasks.

On the design surface of the Control Flow tab, double-click the task.

Source. For more information, see Integration Services Sources.

On the design surface of the Data Flow tab, double-click the source.

Transformation. For more information, see Integration Services Transformations.

On the design surface of the Data Flow tab, double-click the transformation.

Destination. For more information, see Integration Services Destinations.

On the design surface of the Data Flow tab, double-click the destination.

The Advanced Editor dialog box is a user interface for configuring data flow components. It reflects the properties of the component using a generic layout. The Advanced Editor dialog box is not available to Integration Services transformations that have multiple inputs.

To open this editor, click Show Advanced Editor in the Properties window or right-click a data flow component, and then click Show Advanced Editor.

If you create a custom source, transformation, or destination but do not want to write a custom user interface, you can use the Advanced Editor instead.

Business Intelligence Development Studio provides windows, dialog boxes, and menu options for working with Integration Services packages.

The following is a summary of the available windows and menus:

  • The Solution Explorer window lists projects, including the Integration Services project in which you develop Integration Services packages, and project files.
  • The Toolbox window lists the control flow and data flow items for building control flows and data flows.
  • The Properties window lists object properties.
  • The Format menu provides options for sizing and aligning controls in a package.
  • The Edit menu provides copy and paste functionality for copying objects on the design surfaces.
  • The View menu provides options for modifying the graphical representation of objects in SSIS Designer

For more information about additional windows and menus, see the Visual Studio documentation.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft