FIX: Business Intelligence Development Studio (BIDS) crashes when you select a WSDL file in SQL Server 2008 R2

Article translations Article translations
Article ID: 2757344 - View products that this article applies to.
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.
Expand all | Collapse all

On This Page

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 1
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 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.

Properties

Article ID: 2757344 - Last Review: December 17, 2012 - Revision: 4.0
Applies to
  • Microsoft SQL Server 2008 R2 Integration Services
Keywords: 
kbqfe kbfix kbsurveynew kbexpertiseadvanced KB2757344

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com