score:3
You won't.
SSIS packages are bound to the edition (or upgraded to current) of SQL Server they are created against.
- SQL Server 2005 uses VS 2005 to create SSIS packages.
- 2008/2008R2 uses VS 2008. Both of those will be sourced from the SQL Server installation media.
- SQL Server 2012 uses both VS 2010 and VS 2012 to author SSIS packages (same .dtsx file, just different color palates for designer). This can be installed from either the installation media or by downloading SSDT-BI
- SQL Server 2012 uses VS 2013 to author SSIS packages and now the bits only come via the download
- SQL Server 2016 will use VS 2015 to author SSIS packages and, breaking with the above pattern, will be able to create SSIS packages against earlier versions. (As of this answer, 2016 is not released but the speculation is that SQL Server 2012-2016 will all be able to targeted within VS 2015). These bits will also be available exclusively through download and there is a slight change in that process as you will be able to only download what you want (SSIS, SSAS, and/or SSRS)
If you Biml, then while you still need multiple installations of BIDS/SSDT/VS on your machine at least the problem just becomes a matter of "recompiling" to target the version instead of hand coding it per version of SQL Server you have to support.
Launching the correct visual studio
My start screen looks something like
Those are going to all point to the executable devenv.exe
which, by default, will be in C:\Program Files (x86)\Microsoft Visual Studio *
where you need to tie your year-version to internal number
You can find the installation locations for visual studio by issuing the following command dir /s /b devenv.exe
from your C:\ location
C:\Program Files (x86)>dir /s /b devenv.exe
C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe
C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\devenv.exe
C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE\devenv.exe
C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\devenv.exe
C:\Program Files (x86)\Microsoft Visual Studio 8\Common7\IDE\devenv.exe
C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\devenv.exe
More questions
- Visual Studio 2015 SQL Server Data Tools missing "Add Table" option
- SQL Server data tools in visual studio 2015
- SQL Server Data Tools - Visual Studio 2015 Error
- SQL Server Data Tools and Visual Studio Issue
- How to change the connection in Sql Server Data Tools Editor in Visual Studio
- Visual Studio 2013 Build Error: Incompatible versions of SQL Server Data Tools and database runtime components are installed on this computer
- Where does Visual Studio store data connection strings used in SQL Server Data Tools
- SQL Server Data Tools 2017 for Visual Studio 2017 - Unable to start debugger error
- SQL Server Data Tools 2017 with Visual Studio 2010
- Sql Server Data Tools without Visual Studio
- Visual Studio SQL Server Data Tools Comparison Mappings
- Error SQL Server Data Tools for Visual Studio - DQS - System.NotImplementedException
- How to add LocalDB to Visual Studio 2015 Community's SQL Server Object Explorer?
- Source Control tools for Visual Studio 2010 and SQL Server 2008 scripts and database updates?
- Creation of default data in Visual Studio database projects / SQL Server
- How to import data into Visual Studio 2012 Sql Server Database Project
- Visual Studio 2013 has no SQL Server CE Data Provider
- LOAD DATA INFILE in visual studio using SQL server ERROR: "The LOAD DATA SQL construct or statement is not supported"
- Do I need to install SQL Server & SQL Server Management Studio, after installing Visual Studio 2015 Enterprise?
- Visual Studio 2015 without SQL Server
- Visual Studio 2015 Update 2 and Sql Server 2016 Schema Compare
- Why are unit tests greyed out in Visual Studio 2015 for SQL Server project?
- How do I install the Visual Studio 2010 Shell to use SQL Server Data Tools?
- Visual Studio Community: how to view data or run SQL in the "SQL Server Object Explorer"
- SQL Data Tools Visual Studio Syntax error but not in Management Studio
- Access denied to Sql Server mdf file from Visual Studio 2013 data connections
- Visual Studio 2015 Preview breaks SQL Server hierarchyid
- VIsual Studio WinForm connecting to SQL Server Database: C# syntax to transfer the data
- Visual Studio 2015 SQL Server Project. Manage linked server having references to multiple databases
- Why my visual studio 2015 SQL Server doesn't connect with Azure SQL Database?
More questions with similar tag
- SQL Server date datatype default and constraints
- HornetQ Persistence using MS SQL server
- SQL Server 2017 CLR Error: Could Not Find type in assembly
- How to return only records after certain character?
- VB6 ADODB Fails with SQL Compact: Multipe-Step operation generated errors
- Return inserted row
- How to get Count from FromSql?
- Assign Unique Group Id To Sets of Rows with Same Column Value Separated by Other value
- Escape database object names
- How can I store more than 8000 bytes of data inline in a SQL Server 2012 row?
- Extremely Slow SSIS Query
- SQL date conversion to UNIX time stamp gives multiple UNIX times for same time stamp
- How can I shorten this LIKE statement in SQL Server?
- Combining four tables in SQL Server
- UPDATE using SQL Server
- Why are my accented characters breaking in SQL Server 2005?
- File extension Script task and Error handling
- Can I run DBCC CHECKDB from .NET?
- SQL Server LIKE, WILDCARDS, AND, OR operator, braces
- T-SQL query - row iteration without cursor
- How to join sys.databases, sys.tables and sys.columns
- What approach for creating and editing database structure: code or scripts?
- compare comma separated values in sql
- SSIS Excel Connection Manager Error
- Wrapping a transacted Stored Procedure inside a transaction
- need to assign values from sql query in single instance
- Count decline Attempts with CURSOR in Sql Server
- Select columns into an array in SQL Server Stored Procedure
- Flatten sql hierarchical data
- Cast Nvarchar to Int Failing SQL Server 2008