Copy Package Objects
Applies to:
SQL Server
SSIS Integration Runtime in Azure Data Factory
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
In SQL Server Data Tools (SSDT), open the Integration Services project that contains the packages that you want work with.
In Solution Explorer, double-click the packages that you want to copy between.
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.
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
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.
Right-click a selected item and click Copy.
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
You cannot copy a data flow to a package unless the package contains at least one Data Flow task.
Right-click and click Paste.
To copy connection managers
In SQL Server Data Tools (SSDT), open the Integration Services project that contains the package that you want to work with.
In Solution Explorer, double-click the package.
In SSIS Designer, click the Control Flow, Data Flow, or Event Handler tab.
In the Connection Managers area, right-click the connection manager, and then click Copy. You can copy only one connection manager at a time.
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.
Right-click in the Connection Managers area and click Paste.
See Also
Control Flow
Data Flow
Integration Services (SSIS) Connections
Copy Project Items
Geri Bildirim
https://aka.ms/ContentUserFeedback.
Çok yakında: 2024 boyunca, içerik için geri bildirim mekanizması olarak GitHub Sorunları’nı kullanımdan kaldıracak ve yeni bir geri bildirim sistemiyle değiştireceğiz. Daha fazla bilgi için bkz.Gönderin ve geri bildirimi görüntüleyin