How to Enable Integration Services (Ssis) in SQL Server 2008

How to Add SSIS to my SQL Server 2008 R2 Management Studio Installation

please uninstall and reinstall SQL Server Management Studio(Client/Workstation Components) on client PC, in order to work with SSIS.

SQL Server 2008 Express Integration Services

No, it does not. From Features Supported by the Editions of SQL Server 2008 R2:

You need to be running at least Standard Edition.

Adding Integration Services to Previous SQL Server Install

Check if sqlncli.msi exists in %PROGRAMFILES%\Microsoft SQL Server\100\SDK. If it does not exist use the subsequent steps to download, uninstall, and re-install it to resolve this error.

https://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms131321(v=sql.105)?redirectedfrom=MSDN

The SQL Server Native Client header and library files (sqlncli.h and sqlncli10.lib) are installed in the following location:

%PROGRAMFILES%\Microsoft SQL Server\100\SDK

You can distribute (install) SQL Server Native Client through sqlncli.msi. You might have to install SQL Server Native Client when you deploy an application. One way to install multiple packages in what seems to the user to be a single installation is to use chainer and bootstrapper technology. For more information, see Authoring a Custom Bootstrapper Package for Visual Studio 2005 and Adding Custom Prerequisites.

The x64 and Itanium versions of sqlncli.msi also install the 32-bit version of SQL Server Native Client. If your application targets a platform other than the one it was developed on, you can download versions of sqlncli.msi for x64, Itanium, and x86 from the Microsoft Download Center.

When you invoke sqlncli.msi, only the client components are installed by default. The client components are are files that support running an application that was developed using SQL Server Native Client. To also install the SDK components, specify ADDLOCAL=All on the command line. For example:

msiexec /i sqlncli.msi ADDLOCAL=ALL APPGUID={0CC618CE-F36A-415E-84B4-FB1BFF6967E1}

Steps to take if sqlncli.msi does not exist in the documented path

1. Go to Control Panel and uninstall SQL Server 2012 Native Client
2. Download Microsoft® SQL Server® 2012 Native Client - QFE https://www.microsoft.com/en-us/download/details.aspx?id=50402 and install
3. Use SQL Server Installation Center to add SSIS

Add SSIS to existing SQL Server instance

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

Integration services feature is not found in SQL Server 2008 R2 Express Edition?

SQL Server Express does not supports Integration Services.

Business Intelligence Development Studio is not included into Express edition, but it is inculded into Express with Advanced Services edition.

See MSDN for comparison table of features supported by different editions of SQL Server.

You have to install at least Standard edition in order to be able to use Integration Services, but note - is is not free to use like Express edition.

---

Related Topics