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

techresearch7777777 1,796 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,456 questions
0 comments

8 additional answers

Sort by: Newest
Most helpful Newest Oldest
  1. techresearch7777777 1,796 Reputation points
    2022-09-29T23:00:40.557+00:00

    Looks like I finally got VS 2019 & "SQL Server Integration Services Projects" extensions installed, thanks for all the replies.

    0 comments
  2. techresearch7777777 1,796 Reputation points
    2022-09-29T17:57:09.607+00:00

    I downloaded and trying to install "Visual Studio Community 2022 - 17.3.5" which looks like is the free version to develop & test and should be able to create & deploy SSIS packages...if not please let me know which version I need instead.

    The 1st screen tab [Workloads] shows the following with option checkboxes next to each:

    • Web & Cloud (4)
    • Python development
    • Desktop & Mobile (5)
    • Azure development
    • Node.js development
    • .NET desktop development

    Then then 2nd tab [Individual components] lists a whole bunch of:

    • .NET
    • Cloud, database, and server
    • Code tools
    • Compilers, build tools, and runtimes
    • Debugging and testing
    • Development activities
    • Emulators
    • Games and graphics
    • SDKs, libraries, and frameworks

    I'm confused and above seems overwhelming. Which options should I select in above both 1st & 2nd tabs for me to be able to create & deploy SSIS packages to our current SQL Server 2016 Standard edition?

    Thanks in advance.

    0 comments
  3. techresearch7777777 1,796 Reputation points
    2022-09-28T20:54:09.293+00:00

    Thanks NaomiNNN for your helpful reply as well.

    Then is it correct to say in order to build & deploy SSIS packages you're doing it through you're VS 2019 install only and that VS 2022 is unable to do at this moment?

    0 comments
  4. techresearch7777777 1,796 Reputation points
    2022-09-28T06:25:20.007+00:00

    Interesting like you recommend YitzhakKhabinsky-0887...strange why the latest VS 2022 doesn't fully support SSIS creation/deployments in following article By David Ramel07/18/2022

    https://visualstudiomagazine.com/articles/2022/07/18/ssrs-ssis-vs-2022.aspx

    I realize Visual Studio 2019 Community is the free version...so am assessing if it's worth going with this free version for now or wait buying more features of VS 2022 Professional or Enterprise until Microsoft fixes support for SSIS by end of this year like article mentions.

    https://visualstudio.microsoft.com/vs/compare/

    If I install now VS 2019 and Microsoft VS 2022 gets fixed and supports full features SSIS...wondering if it'll be an easy clean uninstall of VS 2019 and install VS 2022 be straight forward or will both versions of Visual Studios need to run side by side and if yes what would be the impact(s)/any overlapping issues?

    Thanks so much.