«

»

Jan
25

SSIS Quick Tip: Copy & Paste Packages into a Visual Studio Project

Categories:

by

2012/01/25

The Add Existing Package option for SSIS projects is very helpful, but has one major limitation. The dialog only allows you to add a single package at a time. When working with a lot of packages, this can be a time consuming process.

image

Thankfully, there is a shortcut. You can add multiple packages to a project using Copy & Paste.

  1. Select the packages you want to add to your projects in Windows Explorer, and Copy (Ctrl-C)
  2. Switch to Visual Studio
  3. Select the Project node
  4. Paste (Ctrl-V)

The packages will be added to the SSIS project (and copied to the project directory).

image

Note: This works in all versions of SSIS.

Related posts:

  1. SSIS Quick Tip: Required Parameters

Tags:

Permanent link to this article: http://www.mattmasson.com/index.php/2012/01/ssis-quick-tip-copy-paste-packages-into-a-visual-studio-project/

1 ping

  1. Importare più pacchetti SSIS in BIDS in un sol colpo! - The SQL Server Side of Me says:

    2012/01/30 at 10:22 am (UTC -5 )

    [...] sono però venuto a conoscenza di un trucchetto che risolve il problema, grazie a questo post di Matt [...]

Leave a Reply