Click here to Skip to main content
15,886,963 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
C#
I am quite new to SOAP.I have been tasked to create a job that generates the below SOAP file on a monthly basis using SQL Server 2008 / SSIS. I am not even sure if this possible using SQL Server / SSIS. If its not possible i have been told to list alternatives and to specify what part is possible using SSIS / SQL Server. I have been stuck with this problem for past week. Please help

.
File format:

Add Request :

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:tem="http://tempuri.org/">
   <soapenv:Header/>
   <soapenv:Body>
      <tem:Add>
         <tem:Name>508</tem:Name>
         <tem:Sales>144</tem:Sales>
       </tem:Add>
   </soapenv:Body>
</soapenv:Envelope>
Get Info Request :

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:tem="http://tempuri.org/">
    <soapenv:Header/>
    <soapenv:Body>
      <tem:GetInfo>
         <tem:StudentNumber>65</tem:StudentNumber>
      </tem:GetInfo>
   </soapenv:Body>
</soapenv:Envelope>
Posted

1 solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900