Click to Rate and Give Feedback
MSDN
MSDN Library
SQL Server
SQL Server 2008
Development
 How to: Copy a Package in Business ...
Community Content
In this section
Statistics Annotations (0)
Collapse All/Expand All Collapse All
Other versions are also available for the following:
SQL Server 2008 Books Online (October 2009)
How to: Copy a Package in Business Intelligence Development Studio

This topic describes how to create a new Integration Services package by copying an existing package, and how to update the Name and GUID properties of the new package.

  1. In Business Intelligence Development Studio, open the Integration Services project that contains the package that you want to copy.

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

  3. Verify either the package to copy is selected in Solution Explorer or the tab in SSIS Designer that contains the package is the active tab

  4. On the File menu, click Save <package name> As.

    ms345176.note(en-us,SQL.100).gifNote:
    The package must be opened in SSIS Designer before the Save As option appears on the File menu.

  5. Optionally, browse to a different folder.

  6. Update the name of the package file. Make sure that you retain the .dtsx file extension.

  7. Click Save.

  8. At the prompt, choose whether to update the name of the package object to match the file name. If you click Yes, the Name property of the package is updated. The new package is added to the Integration Services project and opened in SSIS Designer.

  9. Optionally, click in the background of the Control Flow tab, and the click Properties.

  10. In the Properties window, click the value of the ID property, and then in the drop-down list click <Generate New ID>.

  11. On the File menu, click Save Selected Items to save the new package.

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2009 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks | Privacy Statement
Page view tracker