SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Modifying the fields from Request Data in Web Service Task in SSIS Package


Modifying the fields from Request Data in Web Service Task in SSIS Package

Author
Message
QQ-485619
QQ-485619
SSC Eights!
SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)

Group: General Forum Members
Points: 917 Visits: 321
I have two questions:

1). in the SSIS web service task, in the Input section, i need to remove some field in the data request list (the list of field with name, type, value and variable.


2). I believe this list of comes from a request xml file. If I have a customized request xml file, is there anyway that I can specify that in the web service task in SSIS?

Thanks,

Jian
Attachments
remove_field.docx (9 views, 47.00 KB)
Subramaniam Chandrasekar
Subramaniam Chandrasekar
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3566 Visits: 531
QQ-485619 - Friday, January 5, 2018 3:43 PM
I have two questions:

1). in the SSIS web service task, in the Input section, i need to remove some field in the data request list (the list of field with name, type, value and variable.


2). I believe this list of comes from a request xml file. If I have a customized request xml file, is there anyway that I can specify that in the web service task in SSIS?

Thanks,

Jian

Please use SSIS variables to pass your inputs from your customized xml.

QQ-485619
QQ-485619
SSC Eights!
SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)

Group: General Forum Members
Points: 917 Visits: 321
my question is more about how to make the web service task to use the customized soap request file.
Subramaniam Chandrasekar
Subramaniam Chandrasekar
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3566 Visits: 531
QQ-485619 - Saturday, January 13, 2018 1:21 PM
my question is more about how to make the web service task to use the customized soap request file.

I've got your request now,

Using a SSIS package I am trying to:

make the values read from an XML document / make the xml to save somewhere and point it from XML source

make those values pass to a web service

Save the new values in any flat file as per your wish.

If you still need clarifications, kindly revert back.

Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search