View Single Post
  #5 (permalink)  
Old January 14th, 2016, 06:52 AM
sqldaddy sqldaddy is offline
Registered User
Points: 12, Level: 1
Points: 12, Level: 1 Points: 12, Level: 1 Points: 12, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2015
Location: Miami Lakes, FL 33015
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default SSIS XML Source

have got this thread and Here I would like to answer according to this. I have a package of SSIS XML Source , Where all the things is discussed in well proper way. There are various feature of this package that will helpful to do.
1.Read XML data from any SOAP/REST API Web Service using methods such as GET/POST.
2.Read XML data from single or multiple XML files (use of wildcard allowed. e.g. c:\data\*.xml)
3.Support for Path expression to extract data from any level (e.g. Extract Orders nested under Customer Node).
4.Support for passing custom headers to SOAP or REST Web service
5.Support for looping through multiple files using wildcard pattern (e.g. *.xml).
6.REST API Paging support to loop through multiple requests (see)
7.Support for SQL Server 2005, 2008, 2012, 2014 (32 bit and 64 bit)

We have also discussed some tutorials . Kindly Have a look
http://zappysys.com/products/ssis-po...is-xml-source/

Hope It will be helpful.
Reply With Quote