Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Microsoft distributes Microsoft SQL Server 2008 R2 Service Pack 1 fixes as one downloadable file. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 R2 Service Pack 1 fix release.

Symptoms

Consider the following scenario:

  • In Microsoft Business Intelligence Development Studio (BIDS) for a Microsoft SQL Server 2008 R2 environment, you create a Microsoft SQL Server Integration Services (SSIS) project.

  • You create an SSIS package.

  • From the Control Flow Items node in the Toolbox, you add a Web Service Task.

  • In the Web Service Task Editor dialog box, you create an HTTP connection.

  • You select a Web Services Description Language (WSDL) file, and then you select a Web Service Method in the Input page.

In this scenario, BIDS crashes. Additionally, when you debug this issue, you receive the following error message:

The input Web Services Description Language (WSDL) file is not valid.

Cause

This issue occurs because complex type parameters together with complex type members in the WSDL file are still not supported. However, the check operation ends after it tries to build the all the type members that may cause a stack overflow when the <T> type contains members of <T> type.

Resolution

After you apply this fix, the check operation is changed so that it tries to build only the members that are of the primitive, enum, and array types.

Cumulative update information

Cumulative Update 4 for SQL Server 2008 R2 SP2

The fix for this issue was first released in Cumulative Update 4. For more information about how to obtain this cumulative update package for SQL Server 2008 R2 SP 2, click the following article number to view the article in the Microsoft Knowledge Base:

2777358 Cumulative update package 4 for SQL Server 2008 R2 Service Pack 2
Note Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 R2 SP 2 fix release. We recommend that you consider applying the most recent fix release that contains this hotfix. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

2730301 The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 Service Pack 2 was released

SQL Server 2008 R2 Service Pack 1

The fix for this issue was first released in Cumulative Update 9. For more information about how to obtain this cumulative update package for SQL Server 2008 R2 Service Pack 1, click the following article number to view the article in the Microsoft Knowledge Base:

2756574 Cumulative update package 9 for SQL Server 2008 R2 Service Pack 1Note Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 R2 Service Pack 1 fix release. We recommend that you consider applying the most recent fix release that contains this hotfix. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

2567616 The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 Service Pack 1 was released

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Workaround

To work around this issue, use one of the following methods:

  • Remove the complex types from the WSDL file.

  • Use a script task to call the WSDL file in the same manner as you would use to call a Web Service from a Microsoft .NET Framework-based application.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×