One of our customers had a issue with SSIS. A Windows 2008 R2 standard edition environment with SQL Server 2008 R2 Enterprise edition was installed. However the SSIS Services was not available as service. When a SSIS package was executed the following error apaired:
The SQL Server Execute Package Utility requires Integration Services to be installed by one of these editions of SQL Server 2008: Standard, Enterprise, Developer, or Evaluation. To install Integration Services, run SQL Server Setup and select Integration Services. The package execution failed. The step failed. “
A new installation doesn’t work, because Integration Services was grayed out.
The story behind the first installation was that a error occurred during the first installation, a new installation was executed and was finished succesful. However the SSIS services was not working well.
The solution for this is to uninstall just the Integration Services by ControlPanel-> Uninstall program -> Microsoft SQL Server 2008R2. After the uninstall, install Integration Services via de Setup and the SSIS Services works correct.