.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

URL location of the WSDL File for Web Services File Task

Posted By:      Posted Date: September 13, 2010    Points: 0   Category :Sql Server
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...

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?

WSDL file for Web Services task

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>

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:

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. 

Web Folder problem : This file cannot be saved to this location because there is no connection to th

When I check out a Word 2007 document from a list, I cannot save it back to the server.  I get:   This file cannot be saved to this location because there is no connection to the server.  Check your network connection and try again.   I am using a Virtual Machine (Virtual PC).  I have the Microsoft Loopback adapter installed.    The server has a static IP address and is a domain controller. I am able to access the web folder through Windows Explorer.   How do I set up Office, Sharepoint and Webdav so that I can check files out of sharepoint and save them back, on a virtual machine?

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

what is the better design for location of system database data / log files and user data/log file,

is there a guideline for better performance for system database data location log location, like tempdb location etc. also better location for user databases/data and log.

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="

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)

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?


Opening a MS Word File and setting the save location



I have an ASP intranet site which opens word documents from a shared network drive (link is stored in a DB).  When the user then goes to save the document, it points the user to their default location - say C:\myprofile\my documents.  How can i get it so that the user can just click on save and it saves it in the location it got the file from?  I am using the following code to grab the document:

Response.AddHeader("Content-disposition", "attachment; filename=" & docfilename)
Response.ContentType = "application/vnd.ms-word"

If i navigate through the network share manually through windows, open the document and click save - it will save it to the right location.


How to Use WSDL file in our ASp.net ,c# application


Dear All,

Please try to guide me i am new to this area.i  received WSDL file from my client to access there database. But i dont know how to add the WSDL file to my Asp.net web application and How to use it. Please try to explaine me in detailed iam new .please try give me As soon as possible.

Appriciate  urgent action

Thanking you,


Calling remote batch file using Execute Process Task



The requiement is to create excel file. I cannot run this code using SSIS vbscript task because this requires Microsoft.Office.Interop DLL which can not be installed on the dev / prod server. Hence using the SQL task the data exported to excel.

But now the excel is required to be updated to merge some cells. The approach we are thinking is to keep VBS file with required code to UNC path. Keep the BAT file running VBS file using CSCRIPT command in same location. Call the BAT file from SSIS package using Execute Process Task. This approach is tested in local system and also works on dev server. But somehow the sample code used to create excel is not creating excel to UNC path.

VBS code below

Const xlSaveChanges = 1
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = False
objExcel.Cells(1, 1).Value ="Test value"

The BAT used to call above VBS file is given below

cscript \\server.com\folder$\Demo\Excelfile.vbs

The above UNC path is used in execute process task package which runs fine. But the file is not yet created.


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