Introduction to Extract, Transform, and Load (ETL) with SQL Server Integration Services (SSIS)

Microsoft SQL Server Integration Services (SSIS) is a component of Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. To install,

1. Go to your browser (eg chrome) and google SSMS (SQL Server management Studio)

2. Click on the first link that comes out

3. Open and download it.

4. Add a tab and search for visual studio, open the first link.

5. Go to downloads and click free download.

6. Once its downloaded, right click on the pop up menu indicating downloaded and select show in folder. This is the visual studio installer.

7. Open the installed visual studio installer, navigate through and tick data storage and processing.

8. By the right hand bar under data storage and processing, go ahead and tick SQL server data tools and net framework 7.2 development tools.

9. Under, you can either install while downloading or install (Close)

10. You can install this through your visual studio installer. 

11. Once you’ve done that, you will launch it.

12. After launch, wait for it to open and click continue without code.

13. It will load and open the environment.

14. When you open your visual studio installer, go to extensions

15. Click on manage extensions

16. In the pop up menu, search for services, you will see different services, we have SQL Integration Services, Microsoft Analysis services etc but for the purpose of this class, click on have SQL Integration Services to download and install.

NB: Remember to close every tab/window regarding SQL Server.

17. Open the visual studio installer and check under available. If you already have other communities, you will have to uninstall them.

18. To confirm if it is installed, go to the manage extension on the left hand side.

19. Click on installed

20. You can see all the installed services.