SSIS: Task failed because sgen.exe was not found, or the correct Microsoft Windows SDK is not installed.

You may have come across this error if you try to program against web services in your SSIS packages.

“Task failed because sgen.exe was not found, or the correct Microsoft Windows SDK is not installed”.   If your I.T. Department won’t let you install the SDK and you are out of Freddo frogs, follow these instructions to navigate to and disable the Generate Serialization Assembly option.

1. Open SQL Server Business Intelligence Development Studio or SQL Server Data Tools.
2. Open the project file or the solution file.
3. In Solution Explorer, double-click the SSIS Package to open the Package Designer.
4. Double-click Script Task in the Package Designer to open the Script Task Editor dialog box – Click Edit Script.

ScriptTask

6. In Project Explorer, right-click the project, and then click Properties.

ProjectProperties
7. Click the Build tab. In the Output area, select Off in the Generate serialization assembly list.

BuildTab
8. Make sure you Save Selected Items before you exit.

SaveSelectedItems

 

9. You should now be able to Build your code without error.

About AussieBICG

Connect with me here https://au.linkedin.com/in/aussiebicg

1 Response

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s