Copy Project Items


Applies To: SQL Server 2016

This topic describes how to copy objects within an Integration Services project or between Integration Services projects. You can also copy objects between the other types of SQL Server Data Tools (SSDT) projects, Reporting Services and Analysis Services. To copy between projects, the project must be part of the same SQL Server Data Tools (SSDT) solution.

To copy project level items

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

  2. Expand the project and item folder to copy from.

  3. Right-click the item and click Copy.

  4. Right-click the Integration Services project to copy to and click Paste.

    The items are automatically copied to the correct folder. If you copy items to the Integration Services project that are not packages, the items are copied to the Miscellaneous folder.

Integration Services (SSIS) Packages
Copy Package Objects

Community Additions