Integration Services Loads require installation of BIDS / SSDT-BI

Modified on Wed, 18 Feb 2015 at 04:41 PM

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)

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article