For demonstration, I am creating a simple package that will shrink the database.

Let us create a SQL Server integration service package. The installation of SQL Server data tools has been installed. We are installing development tools for all features, so I have selected all features.

Using SSDT installer, we can install tools for the following features:Īlso, you can set the nickname of the visual studio 2017 instance. These tools are used to develop new integration service packages, analysis cubes, and SSRS reports. On the next screen, you can view the list of tools that you want to install. There are a few links are provided that navigates to the License terms and Privacy statement. You can see the release number on top of the screen. The first screen does not have any information about the SQL Server data tools. Once it is downloaded, double-click on it to begin the installation. It downloads a file named SSDT-Setup-ENU.exe. We are using the stand-alone installer of SSDT 2017, which can be downloaded from here. The SQL Server data tools 2017 (SSDT 2017) is a development tool used for database development, SQL Server analysis service data models, SQL Server report service reports, and Integration service packages.

In this article, we are going to learn how we can install and configure the SSDT 2017 on Windows 10.

Database visual studio 2017 sql server