JSON in SSIS is made easy with the SSIS Productivity Pack JSON components. The SSIS Productivity Pack includes four JSON components, two to transform existing JSON data into column data, the others to transform column data into JSON structure.

These SSIS JSON components offer developers full flexibility and control over their JSON data structure. Developers are able to add, select and deselect nodes and structure their data as needed for input or output.

SSIS JSON Source

The SSIS JSON Source component allows developers to retrieve JSON documents from an HTTP URL or a local file. From there the component will then break up the structure and produce column data which can be consumed by downstream SSIS pipeline components. With JSON Source component developers are able to integrate with virtually any web API including those REST APIs with OAuth2 authentication requirements.

Also available is a JSON Extract component which is a transformation component that can be used within an ETL project to extract JSON data from various sources.

Either component will support as many outputs as needed based on the JSON structure to transform all necessary data into column data to use as required in the downstream pipeline.

SSIS JSON Source component
SSIS JSON Source component - design JSON
SSIS JSON Extract component

SSIS JSON Destination

Using SSIS JSON Destination, developers are able to merge input data based on the JSON data structure defined in the component. You can then specify the component to write the merged JSON document to a local file or you can send it to a HTTP URL to perform a RESTful service call.

Also available is JSON Merge component which is a transformation component that can be used within an ETL project to merge input data into JSON hierarchical structure to use in downstream pipeline.

Either component will support as many data inputs as needed to create the desired JSON hierarchical structure. The transformed JSON data can then be used for many scenarios including sending to a REST web service, or save to a file stored locally or in the cloud.

SSIS JSON Destination component
SSIS JSON Destination component - design JSON
SSIS JSON Merge component

Premium JSON SSIS Components

Download

Supported JSON Sources & Destinations

The JSON Source, Destination, Extract, & Merge components are part of the SSIS Productivity Pack, this is a collection of premium SSIS components to enable greater development productivity. There are many components within this pack that can be used to support development with JSON data as well as dedicated components for many enterprise and commercial applications to make your development job even easier.

Get started with JSON data in SSIS by downloading the SSIS Productivity Pack for free.