Does SQL Server 2008 Express support Integration Services? When I try to create an Integration Services project, it says that I have to install Integration Services, but I cannot find the option in the setup for the installation. How can I install it?
Is there any service pack for this?
The SQL Server 2008 Express with Advanced Services version does have SSIS in the box. If you've not installed that exact version, then you'll need to get the right version to have SSIS.
In order to develop SSIS packages, you need to have features enabled in Visual Studio. For Visual Studio 2010 and higher, those features are packaged in the SQL Server Data Tools that can be downloaded and installed .