Sql-server – How to reinstall SQL Server Integration Services I’ve deinstalled from a Production server by mistake

sql-server-2012ssis

In deinstalling a named instance of SQL Server 2012 from a Production server, inadvertantly, I selected SSIS as a product to deinstall. Now, I need to reinstall it with the least disruption possible.

Best Answer

Run the installer again.

Installing/Configuring SSIS and SSRS to existing SQL Server 2008 database services

Run SQL Server setup program and on the “Feature Selection” page click the checkboxes associated with the features you would like to have installed. When finish, reapply any service pack the instance have applied before.