April 6, 2010 at 8:45 am
The method ResizeImage in my Web service takes an image (a stream of bytes) as a parameter (called imageFileToResize) and is defined as
<s:element minOccurs="0" maxOccurs="1" name="imageFileToResize" type="s:base64Binary" />
in the WSDL file. When I select the method in my SSIS Web service task, I don't see the inputs table with the Name, Type, Value, and Variable columns. Instead, a message is displayed at the bottom of the window "The selected Web method contains unsupported arguments."
However, when I edit the WSDL file and change the type of the element imageFileToResize to a string
<s:element minOccurs="0" maxOccurs="1" name="imageFileToResize" type="s:string" />
then I DO see the Name, Type, Value, and Variable columns.
Is there a way around this so that I can pass a stream of bytes to my Web service task?
August 9, 2010 at 12:24 am
some probleem here!
I've this problem in SQL Server 2008 R2 standard edition.
Trying to connect to Bing webmethod with the web services task.
Downloaded the wsdl file from the webmethod and it's giving me this message.
My assumption was that the WSDL file should describe the webmethod and the parameters. It appears not.
I was wondering what is cause of this message? SSIS? the webmethod? or the WSDL file? or a combination?
What is unsupported? is it a syntax error or a semantic error?
August 9, 2010 at 1:25 am
On http://www.tech-archive.net/Archive/SQL-Server/microsoft.public.sqlserver.dts/2009-04/msg00004.html James Wang (Microsoft Online Community Support) says that "HTTP connection is only used for sending (uploading) or receiving (downloading) files via HTTP". He advices to use the script task.
Keh?
Only uploading files and downloading files? Why such a narrow implementation of a web service task?
Or am i missing something here....
August 11, 2010 at 4:39 am
okay, it seems there something going on here with the web service task:
http://sqlblog.com/blogs/jamie_thomson/archive/2010/05/11/five-things-ssis-should-drop.aspx
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=126247&wa=wsignin1.0
I think there something with supported versions or features of the WSDL file.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply