SSIS can be used to perform a broad range of data migration tasks and workflow applications. For this you will use SQL Server Integration Services (SSIS). Now that you have signed in and started SSDT, it is time to create your first project. This will prompt you to sign in to your Microsoft account: Once the installation completes, click the Windows symbol and open Visual Studio 2017 (SSDT): Once the installation has completed, installing SSDT will add the full set of SQL Server tools into your existing Visual Studio installation. You can install the latest version (15.6.4) here: Installing SQL Server Data Toolsįirst things first, make sure you have Visual Studio 2017 installed. Here we will outline the steps needed to install SSDT and describe how to install a simple SQL Server Integration Services (SSIS) package.
It can be used to build SQL Server relational databases. SQL Server Data Tools (SSDT) is a toolset which provides an environment for users to carry out database design work in SQL Server.
