Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS Web Services Task question Expand / Collapse
Author
Message
Posted Monday, October 14, 2013 12:38 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 24, 2014 6:14 AM
Points: 2, Visits: 287
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.

Post #1504514
Posted Tuesday, May 20, 2014 1:52 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 9:52 AM
Points: 104, Visits: 339
Alan,
I am having the same problem. Have you figure out how to input multiple complex value types?

Thanks,
Post #1572885
Posted Monday, June 30, 2014 5:44 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, November 25, 2014 6:40 PM
Points: 421, Visits: 1,000
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
Post #1587825
Posted Monday, June 30, 2014 8:18 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 9:52 AM
Points: 104, Visits: 339
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.
Post #1587838
Posted Tuesday, July 1, 2014 10:40 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, November 25, 2014 6:40 PM
Points: 421, Visits: 1,000
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 :
SELECT COl1, 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.

Post #1588134
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse