SSDT Component installation file in Visual Studio 2015

Harika Anasuya 21 Reputation points
2023-04-27T12:26:56.35+00:00

Hi Team,

We have SSIS packages for our application which are created using Visual Studio 2015 version. Now we are not able to access the packages as we have upgraded to Visual studio 2017 in our server which is throwing an issue. So, now we would like to get back the same version of 2015 for that, Can I know, which version of Visual studio 2015 component actually has SSDT(SQL Server Data Tools that supports?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
Developer technologies Visual Studio Other
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Yitzhak Khabinsky 26,586 Reputation points
    2023-04-27T13:30:23.9466667+00:00

    Hi @Harika Anasuya,

    I would recommend to install and use the following components:

    • VS2019 any edition.
    • SQL Server Integration Services Projects extension for VS2019.

    Such setup allows to develop SSIS projects targeting SSIS 2012, 2014, 2016, 2017, 2019, 2022.

    https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects

    0 comments No comments

  2. ZoeHui-MSFT 41,491 Reputation points
    2023-04-28T02:08:45.33+00:00

    Hi @Harika Anasuya,

    Now we are not able to access the packages as we have upgraded to Visual studio 2017 in our server which is throwing an issue.

    What's the error?

    You may download VS2015 from here.
    SSDT for Visual Studio (VS) 2015

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.