Using SSIS BIDS with Visual Studio 2012 2013

Question

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

User · Answer

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

User · Answer

Welcome to Microsoft Marketing Speak hell  With the 2012 release of SQL Server  the BIDS  Business Intelligence Designer Studio  plugin for Visual Studio was renamed to SSDT  SQL Server Data Tools  SSDT is available for 2010 and 2012  The problem is  there are two different products called SSDT   There is SSDT which replaces the database designer thing which was called Data Dude in VS 2008 and in 2010 became database projects  That a free install and if you snag the web installer  that s what you get when you install SSDT  It puts the correct project templates and such into Visual Studio   There s also the SSDT which is the  BIDS  replacement for developing SSIS  SSRS and SSAS stuff  As of March 2013  it is now available for the 2012 release of Visual Studio  The download is labeled SSDTBI VS2012 X86 msi Perhaps that s a signal on how the product is going to be referred to in marketing materials  Download links are    Microsoft SQL Server Data Tools Business Intelligence for Visual Studio 2012  SSIS packages target SQL Server 2012  Microsoft SQL Server Data Tools Business Intelligence for Visual Studio 2013  SSIS packages target SQL Server 2014    None the less  we have Business Intelligence projects available to us in Visual Studio 2012  And the people did rejoice and did feast upon the lambs and toads and tree-sloths and fruit-bats and orangutans and breakfast cereals

User · Answer

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 amp MSPPError -2147217396

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

Examples related to visual-studio-2012

Examples related to ssis

Examples related to visual-studio-2013

Examples related to bids

Examples related to sql-server-data-tools