How to know if SSDT is installed and if not how?

techresearch7777777 1,766 Reputation points
2024-03-28T22:59:13.2833333+00:00

Hello, I have VS 2019 installed and need to open and view SSIS dtsx packages on seeing exactly what they're doing.

Believe I'll need SSDT to do this which how do I know if this is installed and if not how?

I went to https://learn.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver16#ssdt-for-visual-studio-2019 (though mentions VS 2022) and opened my VS Installer but doesn't show up similar and can't seem to locate it.

Or if I'm not understanding and/or need something different please let me know.

Thanks in advance.

Visual Studio Setup
Visual Studio Setup
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Setup: The procedures involved in preparing a software program or application to operate within a computer or mobile device.
960 questions
0 comments No comments
{count} votes

Accepted answer
  1. Tianyu Sun-MSFT 27,106 Reputation points Microsoft Vendor
    2024-03-29T02:08:48.99+00:00

    Hello @techresearch7777777 ,

    Welcome to Microsoft Q&A forum.

    After opening VS Installer, you can click Modify, choose Workloads tab, check Data storage and processing workload, on the right, you should see SQL Server Data Tools, check it too. If you still cannot find it, try to switch to Individual components tab, search SQL Server Data Tools, you won’t miss it.

    User's image

    User's image

    User's image

    How to know if SSDT is installed and if not how?

    After you check the SQL Server Data Tools component in VS Installer, don’t forget to click Modify button to install it. If it has been installed, the next time you open VS Installer, you will see that it has been checked, and if you open Visual Studio, you will see related database project templates listed in the create a new project window.

    I have VS 2019 installed and need to open and view SSIS dtsx packages on seeing exactly what they’re doing.

    You may also need to install SSIS extension in VS 2019, please try to open VS, click Extensions, Manage Extensions, Online, search for SQL Server Integration Services Projects extension, click Download and close VS to install it.

    User's image

    Best Regards,

    Tianyu


    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.


1 additional answer

Sort by: Most helpful
  1. Olaf Helper 40,656 Reputation points
    2024-04-01T05:57:39.25+00:00

    Believe I'll need SSDT to do this which how do I know if this is installed and if not how?

    You want to know?

    Start Visual Studio and if you have the option to create a new SSIS project, then SSIS is installed, otherwise not: Install it.

    0 comments No comments