XML : Asked to generate a SOAP file using SSIS/SQL 2008

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 2008/SSIS. I am not even sure if this possible using SQL/SSIS.If its not possible i have been told to list alternatives and to specify what part is possible using SSIS/SQL.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>