Scenario

Integration Services loads on a newly configured computer (PC or server) do not work. You may see an error similar to "Execution of Image WslSDL.exe failed".

Cause

RED Integration Services loads require components that are installed with SQL Server client tools, specifically Business Intelligence Development Studio (BIDS) for SQL Server 2005, 2008 and 2008 R2 or SQL Server Data Tools - Business Intelligence (SSDT-BI) for SQL Server 2012 and 2014.

Resolution

SQL Server 2005, 2008 and 2008 R2
Install Business Intelligence Development Studio from the SQL Server installation media.

SQL Server 2012
Install SQL Server Data Tools from the SQL Server installation media.


SQL Server 2014

SSDT is not included with the SQL Server 2014 installation media and is only available as a download: http://www.microsoft.com/en-nz/download/details.aspx?id=42313)