Thursday, 19 March 2015

Add SSIS to existing SQL Server 2014

Click on SQL server setup (Please note SSIS is not available in SQL server express edition. You need to have SQL server standard edition or higher)
Next Click on ‘New SQL server stand alone installation or add features to an existing installation”
Click Next
Again Click Next
Click on Add Feature to an existing instance of SQL server 2014 and click next
In next page scroll down and click the check box in front of ‘Integration services’ under Shared features
Click next
You will see the account under which SSIS will run, you can change it the service account you With which you run the SSIS later
Click Next
Features summary of SSIS installation will appear
Click Install
The last screen will show status as ‘Succeeded’
You can go to SQL server configuration manager to check that the Integration services are running
Open SQL server configuration manager
Click on SQL Server Services
You should see the SQL Server Integration services Running in the right panel