SSIS: Using WEB Service and XML parsing in SSIS

Web Service is very versatile and almost ubiquitous, like the Third-party Web service APIs used by weather forecasts on major portals, such as mobile clients and server-side interactions, which enable the communication of information between two different platforms through a well-designed Web service interface.

Remember the first time you do the IPhone client and server-side interactive Web Service interface, because we have no IOS platform development experience in client development and server development, there are other projects during the day, can only use the night time to continue to try. Eventually, on the third night, the 3rd set of different versions of the Web Service interface finally interacted with the IPhone client successfully. The first two sets of Web service interfaces can interact, but in pictures and some individual places there is always a loss of data, so the pain of the Web service for me to stay up late experience is still fresh. At that time also very simple, said that overtime work overtime, desperate performance ... But enjoy "try, fail!" Try again, push again, fail again! Try again, push again, fail again, advance again, SUCCEED!!! "" There are problems, there will be a problem can be resolved, and how can not be resolved, in the end must also be able to solve! "The determination and the process.

The WEB service was later used in a US insurance company's BI project because of the privacy protection of an American insurance company for their customer information, as well as some very sensitive business such as money clearing, which they would not easily open to developers. Because there are some very sensitive business related to the internal financial settlement of the customer company and the user account information are implemented through the Web Service interface provided by the customer IT department.

The calling procedure is very simple to implement, and the following uses a U.S. ZIP code Web Service interface to get the locale information for the specified zip code.

Http://www.webservicex.net/uszip.asmx?op=GetInfoByZIP

Enter the US Zip Code, for example, after 54404 commits to see the result of an XML format returned. A small town in the north-central United States of Marshfield, Wisconsin state.

The following shows the use of the Web service interface in SSIS to return the corresponding results for the parameters specified by the descendant.

First, create a new HTTP Connection Manager This connection is used to connect to the XML description page of the WSDL (Web Services Description Language). This page provides the Web Service API interface, as well as the conventions for parameters and return values.