SQL Server Data Tools 2017 with Visual Studio 2010

I have a .NET application using SQL Server 2005 which uses an SSIS package (.dtsx) to import data from .csv files.

That will be upgraded to SQL Server 2017. I have installed SQL Server 2017, but did not install the SSIS capabilities, which I think are parts of the Business Intelligence group and should be available to install.

When I rerun the installation .exe (SQLServer2017-SSEI-Dev.exe) I do not see this as an option.

Does anyone have advice as to how I can install this module so that I can create a .dtsx package in SQL Server 2017?

My development environment is Visual Studio 2010.


#sql-server #sql #visual-studio

3 Likes1.40 GEEK