Error message when you try to build an SSIS script task in SQL Server 2008: "Task failed because 'sgen.exe' was not found, or the correct Microsoft Windows SDK is not installed"
- In Microsoft SQL Server 2008, you add a Web service to a SQL Server Integration Services (SSIS) script task.
- The Windows software development kit (SDK) is not installed on the computer.
- You try to build the SSIS script task.
- Install the Windows SDK.
To download and to install the Windows SDK for Windows Server 2008 and for the Microsoft .NET Framework 3.5, visit the following Microsoft Web site:http://www.microsoft.com/downloads/details.aspx?FamilyID=e6e1c3df-a74f-4207-8586-711ebe331cdc&displaylang=enNote The Windows SDK is also available when you install Microsoft Visual Studio 2008.
For more information about how to obtain Visual Studio 2008 Service Pack 1 Beta, click the following article number to view the article in the Microsoft Knowledge Base:945140 Visual Studio 2008 Service Pack 1 Beta release notes and a list of fixed issues
- Disable the Generate serialization assembly option. To do this, follow these steps:
- Click Start, point to Programs, point to Microsoft SQL Server 2008, and then click SQL Server Business Intelligence Development Studio.
- Open the project file or the solution file.
- In Solution Explorer, double-click the SSIS Package to open the Package Designer.
- Double-click Script Task in the Package Designer to open the Script Task Editor dialog box.
- Click Edit Script to open the Microsoft Visual Studio Tools for Applications (VSTA) IDE.
- In Project Explorer, right-click the project, and then click Properties.
- Click the Build tab. In the Output area, click Off in the Generate serialization assembly list.
- On the File menu, click Exit.
Article ID: 955715 - Last Review: 03/19/2009 22:28:06 - Revision: 2.0
- sql2008relnoteintegrationservices sql2008relnote kbexpertiseadvanced kbtshoot KB955715