SSIS XML Tutorial Part 4 - Using SSIS XML Generator Transform (POST to SOAP or REST API URL)

Finally, use XML Generator Transform when you have data coming from upstream in a Data Flow and yet you still need to pass the generated XML downstream. For example, you want to generate an XML that you need to save to a database or submit it to an XML-based API.

Features:

* Create simple or nested XML documents inside DataFlow Task using simple drag and drop approach
* Ability to create nested XML from Multiple datasets
* Ability to create single XML document for all input records or create one document for each input row from ROOT dataset
* Preview XML structure as you change layout on User Interface
* Ability to join different type of datasets (e.g. SQL Server, Flat File, Excel) to create parent-child relation for nested XML
* Support for SQL Server 2017, 2016, 2014, 2012, 2008 (32/64 bit) and now Azure Data Factory

==============================
SSIS Web API Destination
==============================
SSIS Web API Destination can be used to POST data to any API end point such as JSON API (i.e. POST to REST API) or POST to XML API (i.e. SOAP Web Service). This task provides several advanced options which makes it possible to connect virtually any API Service.

Features:

* POST data to any API endpoint without coding (Read more…)
* Support for windows / basic authentication, client certificate and OAuth (Read more…)
* Support for File upload, REST API POST using Multipart/form-data (Read more…)
* Support for Cookies (Read more…)
* Support for Response Output (includes ResponseText and StatusCode)
* Support for Error Output (Redirect failed request)
* Support for easy Test UI (see request/response)