What is needed to develop an SSIS solution?

The only tool needed to create an SSIS solution is SQL Server Data Tools (SSDT). This tool is a part of Visual Studio and can also be downloaded separately from Microsoft Docs (https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-2017#ssdt-for-visual-studio-2017) for free. Once SSDT is installed and  opened, we'll start creating a new project. Every project is created from a template, and our desired template is Integration Services Project.

The following screenshot depicts how a dialog window looks when opened from the File | New Project menu:

The preceding ...

Get Hands-On Data Science with SQL Server 2017 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.