JSON Components

via SSIS Productivity Pack

Easily work with JSON data in SSIS as if it were column data with the JSON Processing Components, found within the SSIS Productivity Pack.

  Download   Purchase

JSON SSIS data integration and migration

What other applications can you sync with JSON?
Click here for more solutions.

There are five JSON Processing components available for working with JSON Data: Source, Destination, Extract Component, Merge, and Extract Task.

With JSON components, developers have 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.

In our 2023 Release Wave 2, we added the new "JSON Extract Task", which can be used for sending an HTTP request and receiving a response.

The JSON components, part of the SSIS Productivity Pack, supports as many data inputs and outputs as needed.

SSIS JSON Extract Editor

SSIS JSON Source/Extract

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 to extract any complex JSON document or column data already in SSIS pipeline by transforming it into tabular data structure which can be further consumed by downstream SSIS pipeline components.

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/Merge

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 - HTTP
SSIS JSON Destination - design JSON
SSIS JSON Merge component

New SSIS JSON Extract Task

The JSON Extract Task is an SSIS control flow task component used for sending an HTTP request and receiving a response. A common use case for this component is downloading a file.

SSIS Dynamics JSON Extract Task - General
SSIS Dynamics JSON Extract Task - Error Handling
SSIS JSON Extract Task - Error Handling

JSON Component
is available in the
SSIS Productivity Pack

DownloadPurchaseHelp Manual

JSON Components: Data Integration Made Easy

Our solution is easy to use, offering code-less integration between the JSON Components and virtually any other application or database system. Our solution is built utilizing Microsoft SQL Server Integration Services (SSIS), a performant and flexible ETL platform, allowing your team to take advantage of the technologies and skills they already have. The drag-and-drop user interface makes it easy to set up powerful integration within a matter of minutes.

JSON Components are available within the JSON & XML Processing components of our SSIS Productivity Pack, a large collection of premium and unique ETL tools to enable greater development productivity. We also offer several additional connectivity solutions to easily integrate JSON Components with applications such as Microsoft Dynamics 365, SharePoint, Salesforce, and many more.

See our full product offerings for more information.


Other SSIS JSON/Web Services Components

Our JSON & XML Processing components make it easy to integrate with different services within the ETL process. Each component available has been specifically developed to expand and enhance data migration and integration processes. In addition to JSON, the JSON & XML Processing components include:

SSIS XML Connector
XML
SSIS HTML Table Connector
HTML Table

Get In Touch

If you would like to know more specific details about our solutions, or if you have any suggestions about our product offerings, we are always here to listen and help!

Contact Us