Today’s post is from Carla Sabotta - lead writer for the SQL Server Integration Services team.

------

In SQL Server “Denali”, you can undo and redo up to 20 actions in the SSIS Designer.

For a package, undo /redo is available in the Control Flow, Data Flow, Event Handlers, and Parameters tabs, and in the Variables window. For a project, undo/redo is available for the project parameters.

You can’t undo/redo changes to the new SSIS Toolbox, and you can’t undo/redo shared connections.

To undo an action, click the undo button or press CTRL+Z. To redo an action, click the redo button or press CTRL + Y.

clip_image001

You can undo and redo multiple actions, by clicking the arrow next to the button, highlighting multiple actions in the drop-down list, and then clicking in the list.

clip_image002

When you make changes to a component using the component editor, you undo and redo the changes as a set rather than undoing and redoing individual changes. The set of changes appears as a single action in the undo and redo drop-down list.

clip_image003

SSIS Toolbox

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.

clip_image005

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.

clip_image006

The Other Tasks category appears in the toolbox when you select the Control Flow tab or the Event Handlers tab.

clip_image008

The Other Transforms, Other Sources, and Other Destinations categories appear in the toolbox when you select the Data Flow tab.

clip_image010

To move an item to a category

· Right-click an item in the toolbox, and then click one of the following:

  • Move to Favorites
  • Move to Common
  • Move to Other Sources
  • Move to Other Transforms
  • Move to Other Destinations
  • Move to Other Tasks

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

clip_image011

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

clip_image012