[visual-studio-2012] Using SSIS BIDS with Visual Studio 2012 / 2013

I want to use SSIS /BIDS project in Visual Studio 2012.

I have both Visual Studio 2010 and Visual Studio 2012 installed along with Microsoft SQL Server 2012.

VS 2010 was installed first followed by MS SQL 2012 which got me BIDS integrated with VS 2010.

However I cannot seem to find any help on integrating BIDS with VS 2012.

I came across few question on SO related to this topic but all of them had integration with 2010 and not 2012.

I know that with MS SQL 2012 I get a SQL Server Data Tool. Does this mean that Visual Studio 2012 and BIDS cannot be integrated ?

Solution 2012:

I had to update the solution here since one of the answers I received partially solved the issue. The Answer provided by did solve the issue @user2141936 but I kept on getting an BlockMixedArchitectureInstall error while updating an existing instance.

It worked without with creating a new instance!!

Side Note : Installing the update broken my publishing database project onto 2012 server. You need to download and install a DACFramework patch for it.

Solution 2013:

download and install http://www.microsoft.com/en-us/download/details.aspx?id=42313

Today March 6, 2013, Microsoft released SQL Server Data Tools – Business Intelligence for Visual Studio 2012 (SSDT BI) templates. With SSDT BI for Visual Studio 2012 you can develop and deploy SQL Server Business intelligence projects. Projects created in Visual Studio 2010 can be opened in Visual Studio 2012 and the other way around without upgrading or downgrading – it just works.

The download/install is named to ensure you get the SSDT templates that contain the Business Intelligence projects. The setup for these tools is now available from the web and can be downloaded in multiple languages right here: http://www.microsoft.com/download/details.aspx?id=36843

First Off, I object to this other question regarding Visual Studio 2015 as a duplicate question. How do I open SSRS (.rptproj) and SSIS (.dtproj) files in Visual Studio 2015? [duplicate]

Basically this question has the title ...Visual Studio 2012 / 2013 What about ALL the improvements and changes to VS 2015 ??? SSDT has been updated and changed. The entire way of doing various additions and updates is different.

So having vented / rant - I did open a VS 2015 update 2 instance and proceeded to open an existing solution that include a .rptproj project. Now this computer does not yet have sql server installed on it yet.

Solution for ME : Tools --> Extension and Updates --> Updates --> sql server tooling updates

Click on Update button and wait a long time and SSDT then installs and close visual studio 2015 and re-open and it works for me.

In case it is NOT found in VS 2015 for some reason : scroll to the bottom, pick your language iso https://msdn.microsoft.com/en-us/mt186501.aspx?f=255&MSPPError=-2147217396