For that, we are using the Shrink database task. We are going to create an SSIS package that is used to shrink the user database. On the New Project dialog box, expand Business Intelligence and select Integration Services. To create a SQL Server integration service package, click on Create new project link.

I am using default settings and click on Start Visual Studio.

On the next screen, you can select Development settings and choose the color theme. We do not have the visual studio subscriptions, so click on Not now, maybe later link. You can create a new visual studio account by clicking on Create one link. If you have a visual studio subscription, you can sign in to the Visual Studio account. (SSDT 2017) Open Start Menu 🡪 Select Visual Studio 2017. 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.

Visual studio 2017 free download