SSIS Toolbox

 

Updated: November 16, 2016

All components installed on the local machine automatically appear in the SSIS Toolbox. When you install additional components, right-click inside the toolbox and then click Refresh Toolbox to add the components.

When you create a new SSIS project or open an existing project, the SSIS Toolbox displays automatically. You can also open the toolbox by clicking the toolbox button that is located in the top-right corner of the package design surface, or by clicking VIEW -> Other Windows -> SSIS Toolbox.

System_CAPS_ICON_note.jpg Note

If you can't see the toolbox, go to VIEW -> Other Windows -> SSIS Toolbox.

Get more information about a component in the toolbox by clicking the component to view its description at the bottom of the toolbox. For some components you can also access samples that demonstrate how to configure and use the components. The samples are available on MSDN. To access the samples from the SSIS Toolbox, click the Find Samples link that appears below the description.

System_CAPS_ICON_note.jpg Note

You can't remove installed components from the toolbox.

In the SSIS Toolbox, control flow and data flow components are organized into categories. You can expand and collapse categories, and rearrange components. Restore the default organization by right-clicking inside the toolbox and then click Restore Toolbox Defaults.

The Favorites and Common categories appear in the toolbox when you select the Control Flow, Data Flow, and Event Handlers tabs. The Other Tasks category appears in the toolbox when you select the Control Flow tab or the Event Handlers tab. The Other Transforms, Other Sources, and Other Destinations categories appear in the toolbox when you select the Data Flow tab.

The Azure Feature Pack for Integration Services contains connection managers to connect to Azure data sources and tasks to do common Azure operations. Install the Feature Pack to add these items to the Toolbox. For more info, see Azure Feature Pack for Integration Services (SSIS).

  1. Right-click an item in the SSIS Toolbox, and then click one of the following:

    • Move to Favorites

    • Move to Common

    • Move to Other Sources

    • Move to Other Destinations

    • Move to Other Transforms

    • Move to Other Tasks

  1. Right-click in the SSIS Toolbox, and then click Refresh Toolbox.

Community Additions

ADD
Show: