如何使用SSIS / SQL Server 2008生成SOAP文件 [英] How do I generate a SOAP file using SSIS / SQL Server 2008

问题描述

我非常新到SOAP.I的任务是创建一个每月生成以下SOAP文件的作业使用 SQL Server  2008  / SSIS。我甚至不确定如果 此可能使用 SQL Server / SSIS。如果不可能我被告知要列出备选方案并使用 SSIS / SQL指定 可能的哪个部分服务器。上周我一直坚持使用 问题 。请帮助

。

文件格式：
 
添加请求：
 
< soapenv：Envelope xmlns：soapenv =http://schemas.xmlsoap.org/soap/envelope/xmlns：tem =http://tempuri.org/> 
< soapenv：Header /> 
< soapenv：Body> 
< tem：添加> 
< tem：Name> 508< / tem：Name> 
< tem：Sales> 144< / tem：Sales> 
< / tem：添加> 
< / soapenv：Body> 
< / soapenv：信封> 
获取信息请求：
 
< 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> 

解决方案

请看下面的类似帖子

< a href =https://social.msdn.microsoft.com/forums/sqlserver/en-US/d3e1cdf2-a2ed-4b86-84be-48fc4ca3ffaa/sending-a-soap-request-from-ssis> https：/ /social.msdn.microsoft.com/forums/sqlserver/en-US/d3e1cdf2-a2ed-4b86-84be-48fc4ca3ffaa/sending-a-soap-request-from-ssis [ ^ ]

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>

解决方案

Please see a similar thread below
https://social.msdn.microsoft.com/forums/sqlserver/en-US/d3e1cdf2-a2ed-4b86-84be-48fc4ca3ffaa/sending-a-soap-request-from-ssis[^]

这篇关于如何使用SSIS / SQL Server 2008生成SOAP文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！