Export (0) Print
Expand All

Copy Package Objects

This topic describes how to copy control flow items, data flow items, and connection managers within a package or between packages.

To copy control and data flow items

  1. In SQL Server Data Tools (SSDT), open the Integration Services project that contains the packages that you want work with.

  2. In Solution Explorer, double-click the packages that you want to copy between.

  3. In SSIS Designer, click the tab for the package that contains the items to copy and click the Control Flow, Data Flow, or Event Handlers tab.

  4. Select the control flow or data flow items to copy. You can either select items one at a time by pressing the Shift key and clicking the item or select items as a group by dragging the pointer across the items you want to select.

    Important note Important

    The precedence constraints and paths that connect items are not selected automatically when you select the two items that they connect. To copy an ordered workflow—a segment of control flow or data flow—make sure to also copy the precedence constrains and the paths.

  5. Right-click a selected item and click Copy.

  6. If copying items to a different package, click the package that you want to copy to, and then click the appropriate tab for the item type.

    Important note Important

    You cannot copy a data flow to a package unless the package contains at least one Data Flow task.

  7. Right-click and click Paste.

To copy connection managers

  1. In SQL Server Data Tools (SSDT), open the Integration Services project that contains the package that you want to work with.

  2. In Solution Explorer, double-click the package.

  3. In SSIS Designer, click the Control Flow, Data Flow, or Event Handler tab.

  4. In the Connection Managers area, right-click the connection manager, and then click Copy. You can copy only one connection manager at a time.

  5. If you are copying items to a different package, click the package that you want to copy to and then click the Control Flow, Data Flow, or Event Handler tab.

  6. Right-click in the Connection Managers area and click Paste.

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

Community Additions

ADD
Show:
© 2014 Microsoft