Installed SSDT but cannot find SSIS builder

[akom54]

We are upgrading one of our systems to use SQL Server 2017 and we use Integration Services to build SSIS packages and schedule them as jobs in Production. In the past, when I installed SQL Server 2008r2, everything was there after a long but simple install. It appears that everything needs to be installed separately with SQL 2017.

Let me preface this with the fact that before installing SQL Server 2017, I already had Visual Studio 2017 installed on this machine. I am hoping that this is not causing the issue. I installed SQL Server 2017, then SSMS, followed by SSDT, the Data tools. Everything installed successfully but the problem is I cannot find the Data Tools or even any mention of Integration Services on my Windows menu, here is what is listed:

Microsoft SQL Server 2017

Deployment Wizard

Reporting Services Configuration Manager

SQL Server 2017 Configuration Manager

SQL Server 2017 Data Feed Publishing Wizard

SQL Server 2017 Data Profile Viewer

SQL Server 2017 Data Quality Client

SQL Server 2017 Data Quality Server Installer

SQL Server 2017 Database Engine Tuning Advisor

SQL Server 2017 Deployment Wizard

SQL Server 2017 Error and Usage Reporting

SQL Server 2017 Execute Package Utility

SQL Server 2017 Import and Export Data (32-bit)

SQL Server 2017 Import and Export Data (64-bit)

SQL Server 2017 Installation Center (64-bit)

SQL Server 2017 Master Data Services Configuration Manager

SQL Server 2017 Project Conversion Wizard

Microsoft SQL Server Tools 17

Microsoft SQL Server Management Studio 17

SQL Server Profiler 17



Can someone tell me what I am doing wrong and where the SSIS package builder is located?

Thank you,

Al

Continue reading...