Hello, 1. Both within BIDS, and from the command line (dtexec). 2. Yes, from the same machine (my desktop). 3. Haven't tried to create a console app (not sure how to?). 4. I'm expecting an xml return with a list of information. I've tried both return to variable and return to file; same results (same error). Thanks!

With item #3 we are trying to figure out what is at fault, so far all looks very ordinary, so it could be a bug somewhere, please proceed with #3: There is an example below of this post: http://msdn.microsoft.com/en-us/library/hk7y1596%28v=vs.80%29.aspx on how to create the console appArthur My Blog

Not having any luck creating the console app. I followed the example and used wsdl to create the proxy. There weren't any examples of what to do with that, but I did find some other examples and tried them only to get alot of errors relating to undefine services and classes. So, I also noticed that I could create a new "web reference", and followed that and entered some code. Unfortunately it won't compile, complaining about not finding "sgen.exe". I do have the SDK (2.0) loaded, but apperantly it's not in the (right?) path. There is a suggestion to define it via toolPath, but I can't find toolPath anywhere. Help?!?!? Thanks!

Did you see this - http://msdn.microsoft.com/en-us/library/xb5th1ba%28v=vs.80%29.aspx? The effort is small, this is why I took this route, hope you can do it very quick.Arthur My Blog

I appreciate "small efforts"! <GRIN> Can't get to first base - I select "new web site" and the "templates" is empty (for all of .Net framework 2.0. 3.0 and 3.5). I'm really beginning to think that my BIDS installation is incomplete / crippled.

No, you need to have a Visual Studio installed, or you acn get the free version called Web Developer Express http://www.microsoft.com/visualstudio/en-us/products/2010-editions/visual-web-developer-expressArthur My Blog

Hello, I've created a Web Service Task using known good paramters against a known good WSDL against a known functioning web service (as verified using soapUI). Yet when I attempt to execute the Web Service task, I get the output below. I have verified that the actual call never goes out on the wire (via Wireshark). But I have also confirmed that the proxy (.dll) is (apperantly!) being built (via procmon). So, what normally happens after building the proxy, but before actually going out on the wire, which might cause an error against "the target of an invocation", and how do I capture the reall error and trouble shoot this thing? I did turn on package logging, for all details on all events, I see an "On Progress" event stating that the Web Service task is initiated. But the very next log is an "OnError", also the same error message (below). Nothing in between. Neither do I see anything apperantly useful in the system logs. I also turned on breakpoints and only see it entering the web service, then the error exit. SSIS package "Package.dtsx" starting. Error: 0xC002F304 at Web Service Task, Web Service Task: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: Could not execute the Web method. The error is: Exception has been thrown by the target of an invocation.. at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo methodInfo, String serviceName, Object connection, VariableDispenser taskVariableDispenser) at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()". Task failed: Web Service Task Warning: 0x80019002 at Package: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. SSIS package "Package.dtsx" finished: Failure. Thanks in advance! Richard Evans

Questions: How do you run the package? Are you trying it out right from within the BIDS? Did you try SOAPUI on the same machine where BIDS is? If you say create a console app in Visual Studio instead, will it be able to consume this WebService? What kind of a variable are you expecting back? Arthur My Blog