Home » ssis xml parser transform

How to import XML into SQL Server using SSIS

Posted on August 30, 2016November 13, 2017 by ZappySys

Introduction In this post you will learn how to import XML file into target such as SQL Server, CSV, Excel, Oracle. Converting or Importing XML requires flattening XML structure (i.e. hierarchy) sometimes we refer this process as de-normalization. Parsing XML can be tricky depending on how many levels you have and from which level you need data. […]

Reading JSON Arrays from file / REST API

Posted on January 11, 2016December 23, 2020 by ZappySys

Introduction REST API is becoming more and more common and with that you will see explosion in use of JSON data format. One of the questions we get a lot is “How to extract or read array from JSON data file” or “How to read multiple arrays from JSON data“. Example : Store JSON document […]