What's needed to start building & deploying SQL 2016 SSIS packages?

techresearch7777777 1,766 Reputation points
2022-05-26T19:41:21.683+00:00

Hello, I'm a beginner to SSIS.

I have SQL 2016 installed and would like to start building & deploying SSIS packages.

Is it correct that I need to download-install first SSDT for Visual Studio 2017 as versions 2019 & 2022 are extensions/upgrades and relies on base version 2017?

If yes is this the following order I need to download-install to be currently at the latest SSDT for Visual Studio which is required to create & deploye SSIS packages?

1 - SSDT for Visual Studio 2017
2 - and then skip SSDT for Visual Studio 2019 and go straight to SSDT for Visual Studio 2022

Or does my step 2 need to download-install Visual Studio 2017 and then finally step 3 download-install SSDT for Visual Studio 2022?

Or is my overall above not the correct concept or missing something?

Thanks in advance.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,451 questions
0 comments

8 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. techresearch7777777 1,766 Reputation points
    2022-05-26T21:18:28+00:00

    Thanks YitzhakKhabinsky-0887 for your reply.

    But what is the following link https://learn.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver16 in relation to my question and also mentions SSDT for Visual Studio 2022 is higher version that Visual Studio 2019 ?

  2. techresearch7777777 1,766 Reputation points
    2022-05-27T00:12:46.087+00:00

    So is that link SSDT for Visual Studio 2019 is the one I should download-install and no need to download-install SSDT for Visual Studio 2017 on that same page?

    I'm going through an online training class on Pluralsight and from my understanding SSDT for Visual Studio 2019 (& believe 2022) versions are extensions and need the SSDT for Visual Studio 2017 which encompasses the main base components.

    Guess I'm confused & misunderstanding...how/what is SSDT database project relates to my overall situation here?

    Thanks so much.

    Sincerely.

  3. ZoeHui-MSFT 32,586 Reputation points
    2022-05-27T02:02:46.373+00:00

    Hi @@techresearch7777777 ,

    With Visual Studio 2019, the required functionality to enable Integration Services projects has moved into the respective Visual Studio (VSIX) extensions only.

    So there's no SSDT standalone installer for Visual Studio 2019.

    If you are using Visual Studio 2017, you will need the SSDT standalone installer to create Integration Services projects.

    Zoe

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  4. techresearch7777777 1,766 Reputation points
    2022-09-27T23:27:36.037+00:00

    Sorry for the delay.

    Is YitzhakKhabinsky-0887 last post still stand as of today?

    "Just ignore SSDT and VS 2017 completely.
    And stay with (1) VS 2019 and (2) SQL Server Integration Services Projects extension, like in my original answer."

    And that Visual Studio 2022 is not capable/compatible of creating/deploying SSIS packages or it can and I should install higher version VS 2022?

    Thanks for all of the replies.