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>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)