.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

web service task input

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :Sql Server
Hi, I just searched forum and cannot find what I need. From web site for web service calling from SSIS step by step, I setup http connection, and download WSDL file with no problem. I then go to input part to select service and method. After method chosen, I can see 3 parameter variables as all string type. They told me that 1 variable is input string, the other variables are output strings. The main task is to use web service to call the method to pass XML file. I want to know should I create 3 project level variables to hold as corresponding 3 parameter variables? Does it mean that I should copy all XML file content to input parameter variable? How can I see the ouptut value of parameter variables? For output part, I created new file as output.xml file. After package run, it shows me "<Result>The result is null. Either the result is null or the Web method returns void.</Result> ". What does this mean? Thanks for any info or help!

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?

Web Service and JSON input data

Hy, I'm try to build a web service who can get in input a JSON string. My web method is: [WebMethod(Description = "Edit Entity")][System.Web.Script.Services.ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Json)]public string ManageEntity(string _DataIn){ // System.Diagnostics.Debug.WriteLine(_DataIn);            return "{\"Result\":\"OK\"}";} When I try posting some data to the webservice I get the error "No parameterless constructor defined for type of 'System.String'". Why the system try to deserialize my JSON string? Is possible to simple retrieve the string? Thanks Lorenzo SonciniLorenzo Soncini

Web Service, Input with Punctuation

Hello everyone! I hope you're all having a nice week so far. I'm trying to call a web service and the passed string may have punctuation, depending on what the user types in. I currently have an HTML textbox and a jQuery call to the .NET web service.  I definitely think the string with punctuation fails because jQuery will send the string wrong, so I tried a few different javascript encoding functions I could find.  I was never able to encode it successfully and decode it in .NET, saving the string with punctuation.   Basically I have a textbox that a user can update their status in.  If the user wants to use punctuation, I'd like them to be able to.  How can I accomplish this with jQuery and .NET?

SSIS Web Service Task error : SQL 2005

On my dev machine every thing works, When i put my SSIS on QA server for testing, I get following error . Customer has only SQL 2005. Please provide any input on how to resolve this issue. I provided HTTP URL as .asmx?WSDL    already in config file.   Code: 0xC002F304    Source: Log Start Message to Process Manager Web Service Web Service Task    Description: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: The input Web Services Description Language (WSDL) file is not valid.    at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil..ctor(Object connection, String downloadedWSDL)    at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()". End Error DTExec: The package execution returned DTSER_FAILURE (1).Moonis Tahir MVP, MCPD, MCSD.net, MCTS BizTalk 2006/SQL 2005/SharePoint Server 2007 (Dev & Config)

SSIS web service Task

Hello All, How  do you get around the same issue if your string type is based on a client token ?  I downloaded the .wsdl file, was able to see the service name, method and when selecting a method type, I am required to provide a client token which was given to me.  (Name column = clienttoken, Type = string, Value = 2227656 - ec8922 (client token numbers goes there)?  I am new to ssis and need your help please.  Note:  I downloaded another .wsdl file from a public site to test out the web service task and I was able to execute it without any errors.  I am using 2008 version.  Except for this .wsdl file which uses a parameter based security (client token) error message:  Web Service Task] Error: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: The web serrvice threw an error during method execution. The error is: An error occurred when verifying security fro the message..    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.WebServiceT

SSIS Web Service Task Error with WCF Service

I have read all the other posts on this site and have not been able to resolve my issue.For testing purposes i created a very simple WCF service that takes no arguments and returns true.  That is all it does.When i create a winform client and instantiate the service i can run my service method and get true back so i know the service works.I then create a test SSIS package with 1 task, a web service task.  I set the web service tasks properties as follows:http connection: http://localhost/WCF_SSIS_Prototype/Service1.svcwsdl file: C:\...\SSIS_WCF_Prototype\Service1.wsdl  (I know this is not a valid path, i changed it for posting to forum)Service: Service1Method: GetDataVariable: User::BResultWhen i run the package i get the following error:[Web Service Task] Error: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: Could not execute the Web method. The error is: Method 'ProxyNamespace.Service1.GetData' 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()". I'm no

passing XMLDocument object as input to WCF service



i have to write a WCF service which accepts XMLDocument object as input.

In my contract, I have defined a function like this:

bool validate(XmlDocument doc);

In my service, the function is implemented llke this:

public bool validate(XMLDocument doc)


code to validate the doc against an XSD file

From my test project i am passing an XML document.

But it says service cannot be found.

Instead if i define XMLDocument doc inside function like this:

public bool validate()


XMLDocument doc= path of document

code to validate the doc against an XSD file

and contract like this:

bool validate();

it works fine.

It validates the XML against an XSD and returns true or false.

Please help.

Accessing Multiple methods from a web service using web service task



When i am using an SSIS web service task, is it possible to get all the methods information to different tables.


Else if the above case is not possible, can i use multiple web service tasks with same http connection(.wsdl file) to access the web service for each method and then load the info to a table.(if i can do this, is there any performance issue)



Does SSIS Web Service Task work with WCF?


From what I am reading, SSIS Web Service Task does not work with WCF, even though SSIS is 5 years old and WCF is 3. Did they fix it in 2008? R2? Will they ever?

And if it doesn't work, can someone give me pointers on setting up a Script Component to feed some variables to the WCF as inputs?

Thanks in advance.

Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.

WCF client as a windows service or scheduled task



I am consuming a web service in a WCF Client app and subsequently update my DB with the latest updates. The WCF is configured using basicHttpBinding, securityMode of TransportCredentialOnly, and clientCredentialType of Windows.  My timeouts (Close, Open, Receive, Send) are all set to 10 minutes.  I am using a Sql Server Agent Proxy with the correct Domain account (actually the same account that is logged into the server itself) given the SSIS Package Execution subsystem and said Proxy is being used for the 'Run as' in the package Step.  The account is a local Administrator AND a sysadmin.

I want to host this WCF app as a Windows service or a scheduled task. I want to know if I can do this and if so, how to accomplish? This service handles minimum of 100 records to max of 100,000 records. The task needs to be automated and scheduled. Appreciate any inputs.

Thank you


Instruct DataFlow task to Redirect bad input rows to Log file?

Hi all,

I am new to SSIS 2005 packages but have written many in DTS 2000.

I am importing a CSV flat file into a SQL server table with SSIS 2005. How do I tell the Dataflow task to redirect rows that don't have the proper number of columns into a Text log file so I can inspect the bad rows later?

I have pointed the Red Error arrow to a text file and defined all the Columns to redirect the error to the text file. I have set the Max error count to 200. However, the entire package fails at the first bad row in the PrimeOutput() method, indicating that Column 13(the last one in the Row) is missing in a particular row. I have tried setting Ignore the error, but that doesn't work either.

I have created a DTS 2000 package that works on the same CSV input and the same SQL table destination. It seems to have no problem with my instructions.

I must be missing something. Can someone tell me what it might be? I really would like to use SQL 2005 or even SQL 2008 because of the new features available, but I am stuck on what I thought would be a very easy first step (because it is very easy in DTS 2000).

Any help would be appreciated. Thanks...

SOAP as input parameter in a web service method


I have a webservice method which needs to accept SOAP as input parameter. I've worked webservices between .NET clients but I've never worked using raw SOAP so I don't know what to do. The format of the input like this:

<?xml version="1.0" encoding="utf-8"?>
<S:Envelope xmlns:S = "http://schemas.xmlsoap.org/soap/envelope/">
    <ns2:RemoteService xmlns:ns2 = "some.ns.url">
        <param2>Asd Qwe</param2>
        <param3 xsi:nil = "true" xmlns:xsi = "http://www.w3.org/2001/XMLSchema-instance"/>
    </ns2:RemoteService >

How should my method input be to accept this SOAP as parameter?

I'm using ASP.NET web services not WCF.

SSIS 2005-2008 web service task limits



I'm finding some articles or white papers about the limits or incompatibilities of SSIS 2005-2008 web service task.

Any suggests to me, please? Many thanks

Error during execution a web method for a web service task - SSIS 2005



I'm created a SSIS 2005 pkg that refers a wsdl file by a web service task. When I execute the task I can see an error as

"Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: Could not execute the Web method. The error is: cannot possible to find the method 'ProxyNamespace.CreateAndCompleteSubscriptionImplService.action'..    in Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvokerProxy.InvokeMethod(DTSWebMethodInfo methodInfo, String serviceName, Object connection)    in Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo methodInfo, String serviceName, Object connection, VariableDispenser taskVariableDispenser)    in Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()"

I haven't written the wsdl file, but I must use it to use the web service in SSIS environment.

Any suggests to me, please? Many thanks


I can add that the web service is implemented with Java technology and the same wsdl it is used with success inside a .NET application. Thanks

Could be a compatibility issue?

Http connection and WSDLFile path for a web service task - SSIS 2005



I'm trying to create a SSIS 2005 pkg with a web service task. I need to create a Http connection, specifying an Url, and a WDSLFile Path. About these, two questions, please:

a) as URL for the Http connection, can I write f.e. http://mysite/mywebservices/mytestwebservice?wsdl=mytestwebservice.wsdl;

b) has the WDSLFile path to be a local path on my machine?

Many thanks for your suggests.

Using a CompareValidator to check input is a valid date

The CompareValidator can do more than just compare two controls. You can also compare it against several of the main .net data types such as Date, Integer, Double and Currency.

To do this you would set Operator="DataTypeCheck" and instead of setting the ControlToCompare or ValueToCompare attributes as you normally would you use the Type="Date" (or any of the data types I have listed above).

Windows Service Applications Tutorials

You can easily create services by creating an application that is installed as a service. For example, suppose you want to monitor performance counter data and react to threshold values. You could write a Windows Service application that listens to the performance counter data, deploy the application, and begin collecting and analyzing data.
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