From the course: SQL Server Integration Services

Install SQL Server Data Tools (SSDT) - SQL Server Tutorial

From the course: SQL Server Integration Services

Start my 1-month free trial Buy for my team

Install SQL Server Data Tools (SSDT)

“

- [Instructor] Integration services packages are created using SQL Server data tools. You can install data tools as an extension to Microsoft's popular development environment, Visual Studio. The process starts at visualstudio.microsoft.com. Click over to the Downloads page. If you have a license or want to test out the Professional or the Enterprise editions, you can get a free trial here. But for educational and open-source projects, you can get the free Community edition, which is what I'm going to be using. I'll go ahead and click on the button to download the installer. Then once it's done downloading, we can close the browser, and we'll go into the Downloads folder to install it. I'll allow it to make changes to my computer, and then I need to press this Continue button to get everything set up. To install SQL Server Data Tools, we need to scroll down on the first tab until you get to the section called Other Toolsets, and here you'll find an option for data storage and processing. Go ahead and place a check mark there, and over on the right you should see SQL Server Data Tools has already been selected. Next, come down to the bottom and press the Install button. This will take quite a while to download everything, so we'll just skip ahead to the next step. When the installation finally completes, you'll be prompted to sign into your Microsoft Azure account, if you have one. I'm going to choose the option here at the bottom that says "Skip this for now" instead. Then we can choose the color theme that we want to work with. I like the blue theme. I'll choose that one, but feel free to choose whichever you'd like. And then click Start Visual Studio. While that's launching, you can also close the installer here in the background. The last step of the process is to add the Integration Services extension to Visual Studio. To do that, click the link at the bottom of the Getting Started window that says "without code," to open up Visual Studio without using a project. That'll just load the main interface. Then go up to the Extensions menu, and click Manage Extensions. On the left, make sure you have the online extension selected, and then we'll do a search. Type in integration services. That should reveal the SQL Server Integration Services Projects option. Click the Download option, and that'll bring up the web browser again, and download another installer file to the system. Once that's done, I'll close my browser again, and we can actually exit out of Visual Studio. Once again, I'll go down into my Downloads folder, and we'll install that extension. Let's go ahead and start that EXE file. We can choose our language that we want to use. I'll choose English, and then click the next button. Finally, we're going to install this product into the instance of Visual Studio that we just installed, which for me is the Community Edition 2022. I'll press the install button. Once again, we're going to wait as this process completes. When that's done, go ahead and close that installer. So now we're ready to create an integration services project. just to make sure that everything worked as intended, let's go ahead and load up Visual Studio one more time. I'm going to just go ahead and find it over here in my Start menu. Let me expand it there, and we'll launch Visual Studio 2022. On the Getting Started window, choose the option to create a new project. Then we'll do a search on the templates for Integration Services template. We'll find the project listed here. I'll go ahead and select that and press Next. I'll leave the default name of Integration Services Project1. You can name yours whatever you'd like. Also, you might want to note the default file path for your project's files. Go ahead and press the Create button. If everything is installed correctly, you should now see the Getting Started with SSIS page here, as well as the SSIS toolbox on the left side of the screen, that lists out all the different tasks that we can add to our integration services package.

Contents