Using SOAP Headers

• Paul Smith-221741

  SSCrazy

  Points: 2003

  More actions

  November 10, 2006 at 1:26 am

  #114181

  Morning All

  I have been using SSIS to extract XML Data from a Web Service quite happily for a couple of months. However, the company that provides the service have now said that they need a username and password provided ia the SOAP Header.

  Any Ideas on how this is done in SSIS - BOL suggests writing a custom script and while my SQL skills may be just about tolerable, my VB and C# skills fall well short .

  All suggestions / assistance (however trivial) gratefully received.

  Paul Smith

• evoku

  SSC Rookie

  Points: 27

  More actions

  August 19, 2016 at 6:02 am

  #1896332

  If you are using the HttpWebRequest, you can add the userid and password to the header as follows:

  request.Headers.Add("username", strId);

  request.Headers.Add("password", strPwd);

  HTH!

  (OH Geez I thought this was 2016 not 2006... LOL... I am a Forum Newbie!)