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.

SQL Server Data Tools (SSDT) 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

Getting Started

Access samples, tutorials, and videos.

On the design surface of the Control Flow tab or the Data Flow tab, right-click and then click Getting Started.

To automatically display the Getting Started window when you create a new Integration Services project, select Always show in new project at the bottom of the window.

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.

The Getting Started window provides links to samples, tutorials, and videos. To add links to additional content, modify the SamplesSites.xml file that is included with the current release of SQL Server Integration Services. It is recommended that you not modify the <GettingStartedSamples> element value that specifies the RSS feed URL. The file is located in the <drive>:\Program Files\Microsoft SQL Server\110\DTS\Binn folder. On a 64-bit computer, the file is located in the <drive>:\Program Files(x86)\Microsoft SQL Server\110\DTS\Binn folder

If the SamplesSites.xml file does become corrupted, replace the xml in the file with the following default xml.

<?xml version="1.0" ?>

- <SamplesSites>

<GettingStartedSamples>http://go.microsoft.com/fwlink/?LinkID=203147</GettingStartedSamples>

- <ToolboxSamples>

<Site>http://go.microsoft.com/fwlink/?LinkID=203286&query=SSIS%20{0}</Site>

</ToolboxSamples>

</SamplesSites>



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.

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.

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.

SQL Server Data Tools (SSDT) 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.

    To sort by name the packages contained in a project, right-click the SSIS Packages node and then click Sort by name.

  • 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.

For information about how to create packages in SQL Server Data Tools (SSDT), see Create Packages in SQL Server Data Tools

Integration Services icon (small)  Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN:


For automatic notification of these updates, subscribe to the RSS feeds available on the page.

Community Additions

ADD
Show:
© 2014 Microsoft