Add SSIS to existing SQL Server instance

sql sql-server ssis installation program-files
Addie picture Addie · Jun 9, 2014 · Viewed 68.4k times · Source

I am trying to add Integration Services an existing SQL Server 2008 instance.

I went to the SQL Server Installation Center and clicked the option to "New installation or add features to an existing installation." At this point, a file system window pops up. I am asked to browse for SQL Server 2008 R2 Installation Media.

I tried C:Program Files\MicrosoftSQLServer but got the error message that it was not accepted as a "valid installation folder." I went deeper into the MicrosoftSQLServer folder and found \SetupBootstrap but this was not accepted either. It appears that the only way to proceed is to find the Installation Media Folder but I'm not exactly sure what it's asking for.

How can I find the Installation Media folder? Alternatively, other methods for adding SSIS to an existing instance of SQL Server 2008 are welcome.

Thanks.

Answer

Milica Medic Kiralj picture Milica Medic Kiralj · Jun 9, 2014

To add features to an existing instance go to:

  1. Control Panel -> Add remove programs

  2. Click the SQL Server instance you want to add features to and click Change. Click the Add button in the dialog

  3. Browse to the SQL Server installation file (.exe file), and select the Add features to an existing instance of SQL Server option.

  4. From the features list select the Integration Services and finish the installation.

Find more detailed information you can find here: How to: Add Integration Services to an Existing Instance of SQL Server 2005 it applies to SQL Server 2008 also

Hope this helps

Related questions

Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot

I'm trying to import a flat file into an oledb target sql server database. here's the field that's giving me trouble: here are the properties of that flat file connection, specifically the field: here's the error message: [Source - 18942979103_txt [424]] …

Read More
SSIS Connection not found in package

I'm kind of new to SSIS programming, and I'm having some problems deploying an SSIS package. This package runs correctly on my PC, does everything it needs to do ... but when I deploy it cannot find the connection strings. Here …

Read More
Connect to SQL database inside Script Task in SSIS

Inside of a Script Task in SSIS, I need to make a call to an SQL database. I have a connection string that was created when I added the database to the data sources folder, however now I'm not sure …

Read More