SSIS Web Service Task cannot call Services with a space in the name

SSIS Web Service Task cannot call Services with a space in the name by Andy Hinchcliffe

Closed

as Fixed

Type:	Bug
ID:	368606
Opened:	9/19/2008 4:23:05 AM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

If the Web Service is create with the Service name has a space in the name, in the WSDL file the service. The WSDL create in Visual Studio will contain a service name that has the spaces changed to _x0020_. So "My Web Service" will be "My_x0020_Web_x0020_Service". If the Web Service is called from C# then this is not a problem.

However in the SSIS package Web Service Task the service name is shown as "My_x0020_Web_x0020_Service". You then get a list of the methods, selecting one brings up the list of parameters. Setting all these correctly and clicking OK.

Running the package gives an error saying 'The given service is not currently available.'

If the service name is changed to have no spaces, the SSIS package runs fine.

Checking the IIS logs and the SSIS Package isn't calling the Web Method.

If I download the WSDL to a file and then search and replace all the _x0020_ with empty string and save the WSDL file. Then edit the SSIS package, then the SSIS will call the Web Service correctly. It will correctly call web service which don't have spaces in the name.

Details (expand)

English

SQL Server 2005 SP2 - Standard Edition

Integration Services (DTS)

Windows XP SP2 Professional

English

Create a New SSIS Package

Add a new HTTP connection Manager
Set the URL to the web service that has a space in the service name, with the ?WSDL at the end.

Add a File Connection Manager
Set the Create File
Filename C:\XML.xml

Add a Web Service Task
Select the HTTP Connection Manger
Set the location of the WSDL to C:\Service.WSDL
Set Overwrite to true
Download the WSDL
Click Input
Set the Service
Set the Method
Enter the Parameters
Click OK

Run the SSIS Package in BIDS

Error message in the Output window:

'The given service is not currently available.'

Full message:

Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: Could not execute the Web method. The error is: Method 'ProxyNamespace.Services.GetProgrammes' not found..
at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvokerProxy.InvokeMethod(DTSWebMethodInfo methodInfo, String serviceName, Object connection)
at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo methodInfo, String serviceName, Object connection)
at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()".

An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: The given service is not currently available.
at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvokerProxy.InvokeMethod(DTSWebMethodInfo methodInfo, String serviceName, Object connection)
at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo methodInfo, String serviceName, Object connection, VariableDispenser taskVariableDispenser)
at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()".

No error and the Web Method

0 attachments

Spaces are not currently supported in the web service name per WSDL documentation. Visual Studio works around this limitation by replacing the spaces with _x0020_ but the IS task does not have this functionality. We will display an error for this scenario in the next release of SQL Server.

Thank you for reporting it.