![](https://chris.koester.io/index.php/2017/06/06/download-json-data-with-ssis/img/Download.JSON.Data.with.SSIS.png)
Download JSON Data with SSIS
SSIS does not have a built in source component for JSON data, so you’ll have to use the Script Component. When you drag the Script Component into a data flow, you’ll be asked how you want to use it. In this case you’ll use it as a source. Define Output Columns Once the Script Component has been defined as a source, the output columns can be defined. For this post, USGS Earthquake data will serve as an example....