SSIS Toolbox
[This documentation is for preview only, and is subject to change in later releases. Blank topics are included as placeholders.]
All components that are installed on the local machine, including third-party components built for SQL Server 2008 and 2008 R2, now automatically appear in the new SSIS Toolbox. When you install additional components, right-click inside the toolbox and then click Refresh Toolbox to add the components.
You can easily access more information about a component from the toolbox, by clicking the component to view a description at the bottom of the toolbox. Click the Help button next to the description to display the Books Online topic.
In the SSIS Toolbox, control flow and data flow components are organized into categories. You can expand and collapse categories for viewing and you can change the organization of components according to your preferences. You can 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.
When you create a new SSIS project or open an existing project, the SSIS Toolbox is automatically displayed. You can also open the toolbox by doing one of the following:
-
Click the toolbox button that is located in the top-right corner of the package design surface
-
On the View menu, click Other Windows, and then click SSIS Toolbox.
You can dock the toolbox, set it to collapse when docked, and you can close the toolbox.
|
