.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

WSDL file for Web Services task

Posted By:      Posted Date: September 13, 2010    Points: 0   Category :Sql Server
I'm trying to use a Web Service for the first time in SSIS.  I have the httpConnection specified, and the test succeeded.  I have put in a text file the code below, and renamed the file with a .WSDL extension.  I'm getting the error below.  What is wrong with my WSDL file?  Thanks!   Could not read the Web Services Description Language (WSDL) file.  The input WSDL file is not valid.  The follwing error occurred while reading the file.  There is an error in XML document (3,3)...   Code Snippet<?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><helloworld xmlns="http://lesl.com/" /></soap:Body></soap:Envelope>

View Complete Post

More Related Resource Links

Web Services Task Editor: The input Web Services Description Language (WSDL) file is not valid

I am trying to prove I can use SSIS to connect to a web service.  The WS I am trying to connect to was developed by a vendor and covered by a NDA, but I was able to reproduce the issue with a public WS. Here are the steps to reproduce the issue: In the Web Services Connection Manager, I entered http://office.microsoft.com/Research/Providers/MoneyCentral.asmx?wsdl in the URL window.  I am able to successfully "test" the connection I pasted the above link into IE and saved the resulting XML as a .wsdl file on my local machine.  In the Web Services Task Editor, General Tab, I specify the path to the .wsdl file and click on "Download WSDL" button.  No Issues When I click on "Input" and select "MoneyCentralRemote" from the drop-down for Service, I receive an error message saying "This version of the Web Services Description Language (WSDL) is not supported" So the questions are: Did I perform the above steps correctly? What WSDL versions are supported in SSIS? How can I tell what WSDL version was used to create the .wsdl I am trying to access? If the WSDL is an unsupported version, is there a work-around to fix the issue?

URL location of the WSDL File for Web Services File Task

I am finding that in order to have the Web Services Task work successfully the location of the WSDL file has to be on a local drive that SSIS is executing upon.  Is the current intended behavior? In my SSIS task I use a URL path to store information extracted from the Web Service.  The information is stored on a different server than the one that SSIS is running upon.  This works properly without error. I have confirmed that SSIS has appropriate permissions to read/write to that directory on that server.  When I attempt to reference the WSDL file (located in the same URL directory that I am saving the information) I get a web services error, 'The Web Services Name is empty, Verify that a valid web service name is available." When I update the Web Service Task attribute to point to the WSDL file located on a local drive it works correctly.  I have confirmed that both WSDL documents are exactly the same. The behavior seems a little strange...so I must be missing something subtle. ...cordell...

Custom WSDL File generation for Classic Web Services (not WCF)


Hello Folks,

I'm about a custom WSDL File Generation for a Classic ASP.NET XML Web Service.

The issue is I didn't find out how to specify mandatory parameters in my WSDL, since ASP.NET  Web Services are generated on ?WSDL location, I thought I would do that from Web Method Annotations, but I found no issue.

Also I have been on a pose where the developer could hide WSDL Generation by specifying a custom WSDL Binding. But in my case I need to let other system access ?WSDL location with a Customized WSDL.


Thanks for Any Help.



[Analysis Services Execute DDL Task] Error: File system error: A FileStore error from WriteFile occu


Hi ,

iam facing one issue while Running one Dimenstion,i got the data in my fact table,and try to processing into dimenstion,i searched somany sites and Blogs,please find the error details

[Analysis Services Execute DDL Task] Error: File system error: A FileStore error from WriteFile occurred. Physical file: \\?\M:\MSSQL\Data\DnB.0.db\Primary Contacts.0.dim\71.Fact Key.asstore. Logical file: . .


1) i verified space in my server Drives all are sufficent my drive (M:\) is around 459GB free space

2) i verified permissions of this folderCube ,it have proper permissions,actually i ran same cube thrice per a month,iam facing this type of problem this time only

3) i chnaged the settings like Process MeasureGroup like By attribute inplace of ByTable,but not work

4)i changed server configuration setting in msdsrv.ini file and change Bufferlimit  set 1 ,but no Luck

5)i chnaged Maximum connection allowed to reduce 1 or 2

6) i divided my dimenston into subparts based on columns and created New dimenstion but iam seeing same issue.

one more thing iam observing if i processed with By attribute i got the above error,if i processed Bytable i got the

File system error: A FileStore error from WriteFile occurred. Physical file:

Web Services: Increase Your App's Reach Using WSDL to Combine Multiple Web Services


The very tools that have helped drive the growing adoption of Web services, and the enabling abstractions that they provide, can often prevent developers from peeking behind the curtains at the XML standards that make up the Web services stack. This article will offer a solution that enables type sharing between proxies created for complementary Web services, while at the same time providing an opportunity to examine the Web Services Description Language (WSDL) and its interaction with the Web services tools you know and love.

Gerrard Lindsay

MSDN Magazine March 2005

Resource File: Web Services Security Specs and TrustBridge


WS-Security is a recently proposed specification from Microsoft, IBM, and VeriSign. It has been submitted to OASIS for industry standardization. WS-Security builds on the SOAP specification to provide you with a standard mechanism to exchange secure, signed messages in a Web Services environment.

MSDN Magazine October 2002

Fax Services: Send Any Printable File From Your Program in Windows 2000


All versions of Windows 2000 have fax services built in, so sending faxes manually is as easy as setting fax options from the control panel. Faxes can also be sent programmatically in Windows 2000 using either COM Automation or the standard C API. The example in this article uses COM Automation with Visual Basic and MFC to programmatically manage faxing. The objects used for fax transmission, such as the FaxServer and FaxDoc objects, as well as their properties and methods, are explained. Because faxing of files you can't print can be problematic, this process is explained. Finally, this article implements a fax routing extension-a plug-in that exports standard functions and implements routing methods for processing received faxes.

Marcin Kaluza

MSDN Magazine August 2001

why does WSDL file have httpS? i just need http

I built my c# web service.  Tested it.  I built my android app.  Tested it.  All is well.  I tried to get these things to talk to each other...FAIL.  I found these lines in my wsdl. <wsdl:service name="Service1"> - <wsdl:port name="Service1Soap" binding="tns:Service1Soap"> <soap:address location="" /> </wsdl:port> - <wsdl:port name="Service1Soap12" binding="tns:Service1Soap12"> <soap12:address location="" /> </wsdl:port> </wsdl:service> What decided that the path should be https?  I never told it that.  It is overriding IIS which says everything should be http.  Someone please help me before I go ballistic.  Oh and for others developing on android 2.2, it won't take unsigned certs, so you either have to configure a local certificate authority or go http. 

WSDL not working for SQL Reporting Services 2008

I have seutp reporting services successfully, but now i want to generate a proxy to be able to interact progromatically with the reporting services 2008 like I did in 2000 and 2005.  I have tried viewing the WSDL from a command like this:   http://localhost/reportserver/reportservice.asmx?WSDL and I get an error like this:   The path of the item 'WSDL' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. (rsInvalidItemPath) Get Online Help Any thoughts?  I also tried from WSDL.exe, no dice. Thanksl Ben

Migrate documents from File share to Sharepoint Services 3.0

Hi, everyone! One company is planning to migrate from File share, where they are storing all company documents, to sharepoint services 3.0, and begin to use document versioning, is it possible to migrate mass of documents to sharepoint services 3.0 ? Now I have no opportunity to test it, that's the reason why I'm asking.

Task scheduler and System.IO.File.WriteAllText() not working properly

I have a simple console application that has this in mainline:  Console.WriteLine(System.String.Format("the current directory is: {0}", System.IO.Directory.GetCurrentDirectory())); System.IO. File.WriteAllText(@"test.txt", "new contents");   Console.ReadLine(); I compile this in VS 2010 and copy the EXE to a directory named "c:\test".  When I run this code in two different OS's via "Task Scheduler" and "Scheduled Task" I get different results.   In Windows Server 2003 R2 "Scheduled Task" this code will create a file as I would expect, c:\test\test.txt with the proper contents written to it.  When I run this same code on Windows 2008 R2 (64 bit version) "Task Scheduler" it writes the expected contents to an unexpected location, c:\C:\Windows\SysWOW64\test.txt. In both environments if I run the exe's from a command line, it writes to c:\test\test.txt as I would expect. As I understand it, if you don't fully qualify the file name in the first parameter of the WriteAllText method it will write the contents to the file in the directory of the executable however this seems to break down when running in the Windows 2008 Task Scheduler.  I know I can fully qualify the file name or put the expected path in a

Populate a Data Flow Task's variables with values from a .dtsConfig file?

I have an SSIS Project to import exchange rates from an XML file into SQL. The project works when I have certain values hard-coded into variables, such as the URL of the XML File, proxy username and passwords etc. I decided to put in a .dtsConfig file, and have it update the values of the variables in the data flow task. So, one of my SSIS Packages in this solution is called ECBDailyRates.dtsx. It contains one control flow, which is a data flow task. The data flow task is a script task which does some XPATH on an XML file, and then provides outputs to an OLE DB Destination, which in turn puts the data into a table in SQL. That much worked before I put in the dtsConfig file. There are a few variables declared inside the data flow task, such as; PricesXMLUriDaily, String ProxyAddress, String ProxyAddressPort, Int32 etc. etc. These are now being updated from the dtsConfig, which is below. It was my understanding that SSIS would run through the config, and update any of the variables as required, and then run my data tasks. However when SSIS runs my script task, none of the variables have been populated, and so it falls over... as it were :) <?xml version="1.0"?> <DTSConfiguration> <DTSConfigurationHeading> <DTSConfigurationFileInfo GeneratedBy="...." GeneratedFromPackageName="dim_Institution" GeneratedFromPackageID="

How to develop WCF services and host them only using WSDL and schemas provided by client(consumer)?

Hi,I am new to WCF. I have just gone through sample calculator service examples and have very hazy understanding of WCF. I have one requirement  where i need to develop WCF services. I have been provided with WSDL and SCHEMAS and has been asked to develop WCF services part.The client part is ready and they need us to write webservices so they can consume it. Can anyone please xplain how could i begin with and from where ? Also what are schemas (XSD's) used for ? Also how would I make sure that after building webservices I have hosted the webservices in such a way that other people in our network could access them ?I have read forums where you have webservices  but need to write clients which can consume it, but not sure how to approach the above requirement. Any help would be greatly appreciated. Please explain it considering I AM NOVICE/BEGINNER.  Thanks

SQL Server 2005 (X64) Maintenance Clean Up Task Using Hours Option for File Age

I'm running into an issue with SQL Server 2005 64-bit and the maintenance clean up tasks.  I have it set up to delete any transaction logs or backups older than 12 hours.  It seems that there could be some sort of bug because, according to the log files, SQL is running the clean up for 12 days instead.  I've created a work around for this by using execute transact-sql tasks instead, but was wondering if there's a problem with my version of SQL Server, like an SP or patch that I've overlooked. Here's my version information: Microsoft SQL Server 2005 - 9.00.1399.06 (X64)   Oct 14 2005 00:35:21   Copyright (c) 1988-2005 Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

SSIS custom task calling web services response errors.

Hi             I have some code within a .Net 3.5 library which call a web service.  The web proxy class was created using WSDL command line tool.  Also the library is wrapped within .Net console, for testing the library works, and SQL Server Integration Services custom task, which is intended to use so that it will be part of the ETL process.    If I run the SSIS custom task and console application on a Windows XP everything works as expected.    However I am currently facing a problem where the response from the web service is not being interpreted correctly when running within the SSIS custom task on windows server 2008 R2, whereas the response from the web service is correctly understood when running the library within console application on the same server.    Has anyone come across this problem before or know any issues with SSIS and .Net libraries which call web services?

How to make use of WSDL+XSD file?

I have to consume a web service created in a Java platform.  The web service is not up yet.  All I have been given are the WSDL file and a XSD file specifying the web service.  How can I make use of these two files to set up the stubs to do my testing of the web service?

I ran wsdl.exe and put both files on the command line and it generated a .cs file.  Then I tried instantiating classes defined in this file.  But the methods do not appear to be what I need.  Is the right approach?


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend