SSIS XML Parser Transform

SSIS XML Parser Transform can parse XML string into multiple columns and rows (Helpful to extract data from raw XML string stored as database column or coming from other source).

Features

Parse source XML String/Documents into multiple columns/rows.
Ability to de-normalize nested XML data into flat structure
Support for expression to extract nested data and convert single node into multiple rows (e.g. extract orders from customer document using expression $.Customer.Orders[*])
Option to parse output from command line Standard Output Stream (e.g. cmd:>curl -k http://httpbin.org/get)
Allow Regular Expression in Filter (e.g. $.store.books[?(@author =~ /^sam$/ )]
Support for SQL Server 2022, 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
Articles/Tutorials: XML related articles

SSIS XML Parser Transform – Parse XMl Document, Convert XML to CSV or save to RDBMS (e.g. SQL Server, MySQL)

Articles / Tutorials

Click here to see all articles for [SSIS XML Parser Transform] category

Parse XML string into multiple columns and rows using SSIS

Introduction In our previous blog we saw How to export XML from SQL Server using SSIS. Now in this blog, we willÂ Parse XML string into multiple columns and rows usingÂ SSIS XML Parser TransformÂ can (Helpful to extract data from raw XML string stored as database column or coming from other source). Ability to de-normalize nested XML […]

Read / Write Zoho CRM data using SSIS REST API Call

Introduction In this post, you will learn how to read / write Zoho CRM data using SSIS (Drag and drop approach without any coding).Â We will useÂ SSIS JSON/ REST API SourceÂ to extract data from Zoho API and useÂ SSIS Web API DestinationÂ to write data to Zoho. We will look at step-by-step instructions to read Zoho CRM […]

Load SQL Server data to Workday using SSIS / SOAP API

Introduction In our previous article, we saw step-by-step approach to read data from workday using SSIS. In this article, we will focus on how to load SQL Server data to Workday (e.g. POST, Create, Update). We will useÂ SSIS Web API DestinationÂ and the combination of other Transforms such as SSIS Template Transform and SSIS XML Generator […]