SSIS Web Services Task question

Question

Post reply

SSIS Web Services Task question

Alan Lewis

SSC Enthusiast

Points: 183
More actions
October 14, 2013 at 12:38 pm

#281344

I am new to SSIS and trying to add a variable to the Web Service Task Input section. In the "Enter Values for complex type", there are 3 input variables that I can type in. Instead of typing them in on that screen, I would like to enter them in as a variable and check the variable box in the fourth column. How do I format a variable for multiple values? I need to pass in a limit, page & sortfield values.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

pcq0125 SSCrazy Points: 2887 More actions · Answer 1

Alan,

I am having the same problem. Have you figure out how to input multiple complex value types?

Thanks,

MMartin1 One Orange Chip Points: 27764 More actions · Answer 2

I think you mean to say that you want one variable to hold three values... and pass this to one method on the web service.

You can pass the values as a string in comma or other delimination ('val1, val2,val3'). This would depend I think totally on the method being called and how it wants its input. Did I understand correctly?

Thanks

----------------------------------------------------

pcq0125 SSCrazy Points: 2887 More actions · Answer 3

That is correct. However my method is an XML complex types. Will the delimited works without the xml tags? I have tried inserted xml string into the variable but got an object type error? Do you know how I can create an object by u by retrieving data from a database?

Thanks for your help.

MMartin1 One Orange Chip Points: 27764 More actions · Answer 4

The XML data type is not intended to be comma delimited, it is a different way of structuring data. So you are not able to pass the whole xml data as a string? I have no experience with passing a xml structure. Does your xml data originate from Sql Server? One thing you could try is setting your variable as a OBJECT type and pass it the results from a xml formatted recordset.

Example :

SELECTCOl1, COl2, ... , Coln

FROM MyTable

FOR XML PATH ('YourRecords'), ELEMENTS

If this does not work you may need to add another method to the web service to accept a string (tags and all) and cast it into XML on the backend.

----------------------------------------------------