SQL Server Data Tools (SSDT)

Question

Hi,

I need to run a 2019 (150) SSIS package on a machine without Visual Studio or SQL Server installed, only SQL Server Management Studio.

Is there a way to install SQL Server Data Tools (SSDT) on the machine without Visual Studio or SQL Server? What's the correct download?

I've only found here...

https://learn.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver15

... however, it seems to indicate you need to install Visual Studio, which isn't desirable.

Answer 1

If you want to use Visual Studio together with the Data Tools, then you can use the free VS Commuinty Edition, see

[https://learn.microsoft.com/en-us/answers/questions/826062/about-license-for-using-sql-server-data-tools-(ssd](https://learn.microsoft.com/en-us/answers/questions/826062/about-license-for-using-sql-server-data-tools-(ssd)

Answer 2

Hi @michael Lang,

SSDT is no more for SSIS.

SSIS has two environments:

1. Development environment on the developer workstation with two software products installed (1) VS2019 or VS2022, (2) "SQL Server Integration Services Projects" extension for VS. This particular piece replaced the SSDT.
2. Production environment on the SSIS run-time server with the following installed: SQL Server database instance with SSIS component.

Answer 3

Hi @michael Lang,

SQL Server Data Tools (SSDT) is a modern development tool for building SQL Server relational databases, Integration Services (IS) packages and so on.

If you want to design or edit packages you may need to install VS for the core SSDT functionality to create database projects has remained integral to Visual Studio.

If you want to run DTExec.exe on the command line to execute an SSIS package, you need to install SQL Server and make sure to select Integration Services.

Regards，

Zoe Hui

---

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