Can't create ssis package in Visual Studio

问题:

I can't seem to figure out why I can't create new SSIS packages in VS2015. I have installed:

• VS2015 community ed.
• SQL Server 2016
• SSDT
• SSMS

If I right click in the solution explorer on "SSIS packages" there is no dropdown menu, which should be there.

If I right click in the Connection manager area, nothing happens, no drop down, nothing.

Am kind of clueless, can't find anything on Google regarding this issue.

回答1:

These are the basic steps to create a new SSIS package.

1. Create or open an Integration Services project
2. Right click the "SSIS Packages" folder
3. Choose "New SSIS Package"
4. Follow the prompts

If this is not possible to follow these steps on your machine then there is a problem with your installation. Make sure your version of SQL Server Data Tools (SSDT) matches your Visual Studio version. SSDT can be downloaded from here: https://msdn.microsoft.com/en-us/library/mt204009.aspx. I hope this helps.