Tips ‘N’ Tricks – SSIS – Quickest way to add an existing SSIS Package to a Project

We often add one or more existing SSIS Packages to an Integration Services Project in SQL Server Business Intelligence Development Studio (BIDS). And like many other scenarios, in this scenario also there are two approaches to perform this action. Let’s take a look at both the approaches in this tip.
 

Regular Approach (5 Steps)

  1. Right click on the SSIS Packages folder in the Integration Services Project in BIDS and Select Add Existing Package from the context menu.
  2. In the Add Copy of Existing Package dialog box select Package location as File System from the dropdown.
  3. Click on the ellipsis button next to the Package path textbox.
  4. Locate the SSIS package (.dtsx file) which you want to add from the file system.
  5. Click OK in the Add Copy of Existing Package dialog box to finish adding the package.

Shortcut Approach (4 Steps)

  1. Locate the SSIS package (.dtsx file) which you want to add from the file system.
  2. Right click on the SSIS package in the file system and select Copy from the context menu (or alternately, select the Package and press Ctrl+C to copy the package).
  3. Right click on the SSIS Packages folder in the Integration Services Project in BIDS.
  4. Select Paste from the context menu to finish adding the package.

Note: This has been tested with BIDS 2008/2008 R2.

 
Advertisements

About Dattatrey Sindol (Datta)

Datta is a Microsoft BI Enthusiast, passionate developer, and a blogger. View Full Profile

Posted on May 10, 2012, in BIDS, BIDS Tips, Shortcuts, SQL Client Tools, SQL Server, SSIS, SSIS Tips, Tips 'N' Tricks and tagged , , , , , , , . Bookmark the permalink. 3 Comments.

What are your thoughts?

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: