SQL Server 2008 Express Integration Services

问题:

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? thanks

回答1:

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

You need to be running at least Standard Edition.

回答2:

Microsoft SQL Server 2008 Express doesn't support Integration Services at it's fullest. It will support, access to basic data sources, but not the full suite that is included in the Standard edition of MSSQL Server 2008.

I don't believe there is a way around this. It's part of the installation package and I don't believe Express has the necessary programmatic pieces for Integration Services.