error while executing SSIS package with web service task

Question

Description: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: The Web Service threw an error during method execution. The error is: Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- IIS 7.5 Detailed Error - 500.24 - Internal Server Error

Server Error in Application "DEFAULT WEB SITE"

Internet Information Services 7.5

Error Summary

HTTP Error 500.24 - Internal Server Error

An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode.

Detailed Error Information

Have a look at the following question: http://stackoverflow.com/questions/4209999/an-asp-net-setting-has-been-detected-that-does-not-apply-in-integrated-managed-p — steoleary, Apr 08 '13 at 14:30

score 0 · Answer 1 · answered Jun 03 '13 at 20:35

0

Change your application pool properties to:

.NET Framework Version
-- .NET Framework *version*

Pipeline Mode
-- Classic

answered Jun 03 '13 at 20:35

cgalvao1993

148
2
18

score 0 · Answer 2 · answered Apr 19 '18 at 17:19

0

change your web.config like this:

<system.webServer> 
<validation validateIntegratedModeConfiguration="false" /> 
</system.webServer>

answered Apr 19 '18 at 17:19

Eduardo Acuña

71
3

error while executing SSIS package with web service task

Server Error in Application "DEFAULT WEB SITE"

HTTP Error 500.24 - Internal Server Error

An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode.

2 Answers2