SSIS - After 'exclude from project', how to re-include?

After I've excluded a package from a project by choosing Project->Ex开发者_StackOverflow中文版clude From Project, how do I 're-include' it later?

I thought it was Project->Add Existing Package, but that adds a copy of the package.

---

It's very easy ,

if it's old version of Visual Studio like 2012 ,

just Right Click on the folder > Add > Existing Item > choose the file which has been excluded

if it's old version of Visual Studio like 2008 ,

Right Click on the folder > Add > Include in Project

---

According to the documentation, SSIS will copy your existing package and place the new copy into your project's folder location. However, if your package is already in this location, it is supposed to just open the package. Since you excluded the package, including it again should work fine without it making a copy of it. The thing I notice, however, is that you don't mention getting an error. Normally you would get an error if you were making a copy and it was being placed in the same location as the original. Most like either you are renaming the package during the "Add Existing Package" stage, or your package isn't in the correct location.

If your package is getting copied with a new name, I have found some indication that this might be a bug. The work-around seems to be to then delete the original and rename the new copy. It isn't pretty but it seems to be your best option.

---

The answer is that you cant just "include" a package. Its more of an import which makes a copy... if the package already exists it adds a (1) to the name of the package.

This is the functionality for SQL Server Business Intelligence Development Studio that comes with SQL server 2008 R2. Doesn't make much sense but Im sure they fixed that in future BIDS releases

---

In Visual Studio 2015, I have found that I can re-include packages by right-clicking on the project and choosing Add | Existing Item... (not Existing Package).

It makes no sense, but it works. I guess it will work the same in other versions of VS.