Post reply

Data Tools

  • November 7, 2018 at 4:37 am

    #409295

    Hello
    Which versions of data tools / visual studio can I install side by side to support SSIS packages on  sql Server 2016 SP1 and Sql Server 2008R2 SP2?

    Thanks

  • November 7, 2018 at 4:44 am

    #2012674

    For SQL Server 2008 you'll needs BIDS on VS2008 (which, if i recall correctly is on the installation media for SQL Server 2008(R2)). For SQL Server 2016, you can use SSDT for Visual Studio 2015+. The latest version is SSDT for Visual Studio 2017 and supports SQL Server 2012+ (including SQL Server 2019 Preview as of V15.8.1).

    The latest version is SSDT for Visual Studio 2017. V15.8 supports SQL server 2012 - SQL Server 2017, and V15.8.1 supports SQL Server 2014+ (including 2019 Preview).

    You can have any number of different versions of Visual Studio installed on a PC. For example, I have both Visual Studio 2017 and 2015 installed on my Work PC. That Visual Studio, however, can only have one version of SSDT against it (so you couldn't have both SSDT V15.8 and V15.8.1 for VS 2017 installed).

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply