Tag Archives: performance tips

Configure XML source or JSON Source for Very Large Data File (Streaming mode for High Performance)

How to read large XML / JSON file in SSIS (3 Million Rows in 3 Mins)

Updated on by ZappySys

Introduction In this post we will learn how to use ZappySys SSIS XML Source or ZappySys SSIS JSON Source  to read large XML or JSON File (Process 3 Million rows in 3 minutes – 1.2 GB file). If you use default settings to read data then it may result into OutOfMemory Exception so we will outline […]