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


Post New Web Links

Accessing Multiple methods from a web service using web service task

Posted By:      Posted Date: October 02, 2010    Points: 0   Category :Sql Server
 

HI, 

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

or 

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)

 

Thanks




View Complete Post


More Related Resource Links

Secured web with unauthenticated users accessing a service

  

hi all,

I have a following configuration:

~/ui/login.aspx, ~/ui/page1.aspx, ~/service/main.asmx

access to web is secured using:

<authentication mode="Forms">
  <forms loginUrl="~/ui/login.aspx" timeout="10" />
</authentication>
<authorization>
<deny users="?" />
</authorization>
 

but I want to allow unauthenticated users to issue (possibly limited set of) a query to the service (e.g. to display service version on the login page using service call ~/service/main.asmx/GetFullVersion). I'm able to do it locally, but on the server there is a problem and the service cannot be queried. I tried to set

  <location path="~/service/main.asmx/GetFullVersion">
<system.web>
<authorization>
<allow users="*"/>
</authorization>
</system.web>
</location>

and

  <location path="~/service/main.asmx">
<system.web>
<authorization>
<allow users="*"/>
</authorization>
</system.web>
</location>

and


  <location path="

Multiple services in REST Collection WCF Service?

  

After I create a "REST Collection WCF Service" project, it contains one service "service.svc". Can I add multiple services to this project? There must be a way to do so. Otherwise, it does not make sense to create one project for each service.

 

My question is how to add a new service to an existing "REST Collection WCF Service" project?

 

Thanks a lot.


WCF Needs? How to Communicate Multiple Contract via Single Service?

  
why it needs.   i have many business objects how could i serve to my web application via single service.   i have nearly 500 different business objects. how could contract implement into client web applicatoin.    

Accessing a WCF Service Application from a web application

  
Hi,I have a VS2K8 solution with a web app and a WCF Service App. In my web app I've added the service reference and can get to the service in the service app from code behind:WebTest.ServiceReference1.Service1Client prox = new       WebTest.ServiceReference1.Service1Client("WSHttpBinding_IService1");            fromStandAlone.InnerHtml = prox.GetData(9);            prox.Close();Can someone post a walkthrough on how to add an AJAX Enabled WCF service to the service app and how to access it from the web app?

Exposing WCF Service for multiple clients with the feature of multiple database support

  
i have ceated a WCF service and hosted it properly. now i want to Exposing this Service for multiple clients with the feature of multiple database support.In this functionality how could i do the proper multiple database management. what i am doing now:1. i am taking database string from the client.2. Then setting the refference of above provided database to the all functions call.ISSUE: if the mulitple clients calling the service at the same time and both are giving different database string then the database string provided by the clients is overlapping.....

Accessing a published web service gives null ref exception. Won't occur in test though?

  
I have an Asp.net web service that I created using Visual Studio 2005. I can acess the web service in my testenvironment, call methods and return data as expected. If this web service is published to the outside world (Outside of the company firewall), it will return a null reference exception. Does anyone have any idea why this might be happening? The same code is being used,against thesame database. The only difference is that the published website is giving back the null reference exception. If I type in the URL for the web service "https://secure.theSiteGeist.com/wsIndigo.asmx" a list of methods forthe web service is displayed in my browser. Yet if I try and call any methods on the web service I getback the null reference exception. Note that the URL I posted above is not the real name of my web service, but isjust used for reference sake.

Error while invoking wcf service and running its methods

  
Failed to invoke the service. Possible causes: The service is offline or inaccessible; the client-side configuration does not match the proxy; the existing proxy is invalid. Refer to the stack trace for more detail. You can try to recover by starting a new proxy, restoring to default configuration, or refreshing the service.    I am using a wcf service with some methods in it called by some layers wherein i am putting all my business logic.While invoking the service from wcftestclient  and when running few methods i am getting this error . I am getting output for some methods in the same service but for some other methods i am getting this error . I am using LINQ in the methods.    My solution has number of projects .For running the service ,i am right clicking on the project and viewing in the browser as i cannot build whole solution as i have few errors in some unit test projects.       As i am getting output for some methods ,this is definetly not about starting the service .  

Web service authentiation when mixed authentication methods are used

  
I am trying to pull data from the list.asmx web service from a console application. I am using clams based authentication, and whenever only integrated Windows Authentiation is checked everything works fine. Whenever I also check Enable Forms Based Authentication I start getting an Acccess is denied error when I try to connect to the service. I can login successfully using FBA so I don't think the problem is caused by the FBA configuration. Does anyone have any ideas to what might be causing this?

Incorrect hostname in EndPoint location in WSDL for a service with multiple bindings and with multip

  
We have a WCF web service that is exposed through multiple bindings.  The site is  accessed through multiple IP Addresses/Hostnames (internet/intranet).  Some of the bindings use http transport while others use https transport. The web application is configured to use .NET 4.0 with multipleSiteBindingsEnabled="true" so that we shouldn't have problems with multiple ip addresses/hostnames. What we see is that when the WSDL is accessed using a http based URL (external), the hostnames in the endpoint addresses for http transport based bindings in WSDL are correct (ie, they use the hostname header from the request) while the hostnames in the endpoint addresses for https transport based bindings in the WSDL are incorrect (ie, they do not use the hostname header in the request - they seem to use the hostname from the first available binding in IIS for that scheme and end up with the local machine names/ip addresses in the URL).   We could work around by setting the external hostname/ip in the first binding in IIS for the respective scheme, but then WSDLs accessed from intranet clients would have wrong URLS now. This happens the other way around as well, ie, when the WSDL is accessed using https, the https based addresses are fine, but http addresses in the WSDL are not correct. It looks like hostname header is used only for WSDL endpoint addre

How to use single windows service to host multiple WCF Services instances (Each instance of WCF is i

  
How to use single windows service to host multiple WCF Services. I have a mutiple instance of same WCF service in different folder, each instance has unique service name and port. WCFService has reference to Reg-Free COM Reference, i have Native.WCFService.manifest in each folder. Ex: WCFService1 is in "C:\WCFService01\WCFService.dll, Native.OCWCFService.manifest, OCWCFService.dll.config WCFService2 is in "C:\WCFService02\WCFService.dll, Native.OCWCFService.manifest, OCWCFService.dll.config Now i need host above services from single Windows Service. I am trying to create AppDomain for each above WCFService Instance from Windows Service and then host. Its working if i register COM dll in the server using regsvr32, but when i un register COM dll, i am getting unable to load COM component .... This looks like AppDomain is not loading COM DLL and Manifest files. Its looks strange but we need it in this way because we have production and test environment in the same server. Everything works fine if create a seperate Windows Service for each WCFService Instance, but my manager wants single Windows Service :). Any help whould be really appreciated.  ravi kumar reddy

web service task input

  
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!

Multiple role providers for a service

  
Is it possible to hook multiple role providers with one service? I want client A  to connect to service A with roleprovidername A   & client B to connect to service A with roleprovidername B  Is this possible ? Thanks in advance.

Multiple role providers for a service

  
Is it possible to hook multiple role providers with one service? I want client A  to connect to service A with roleprovidername A   & client B to connect to service A with roleprovidername B   Is this possible ?   Thanks in advance.

Deploy XBAP application with WCF Service Reference into multiple environments

  
Hi, we have a multiple environment setup (local, Development servers, QA servers, prod servers, etc.) and we are building an XBAP application that uses WCF Services to connect to databases.  We code and unit test everything locally and then deploy to our Development servers for more thorough unit testing.  The issue that we are having is that we don't see how to update the deployed XBAP application to use the Development server deployed WCF Service.  The only way we've been able to do this is by having to change the reference on my local machine, complie, and redeploy the XBAP.Question:  How do we configure a deployed XBAP's Service Reference to point to the same service on a different server than what it was originally compiled/deployed with?  (Like in some configuration file...NOTE: but we also don't see a config file after deploying the XBAP.)  We don't want to have to update the Service Reference for QA, Prod, Training, Stage, etc. on our local machines, compile and redeploy every time we need to migrate the application to a new environment.Thanks!

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
Categories: 
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