SSIS JSON Integration Pack

SSIS JSON Integration Pack is a toolset to automate JSON integration scenarios in SSIS (e.g. Consume/Produce/Parse). Using a simple drag and drop interface you can read data from JSON files or JSON Web Service (i.e. REST API). It includes JSON Source Connector, Export JSON File Task, JSON Parser Transform and JSON Generator Transform.

SSIS JSON Integration Pack

  • Read JSON data from any REST API Web Service using methods such as GET/POST.
  • Read JSON data from single or multiple JSON files (use of wildcard allowed. e.g. c:\data\*.json).
  • Support for Path expression to extract data from any level (e.g. Extract Orders nested under Customer Node).
  • Support for passing custom headers to API Web service.
  • REST API Paging support to loop through multiple requests.
  • Parse source JSON String/Documents into multiple columns/rows.
  • Ability to...

Latest News

SSIS JSON Integration Pack v2.5
SSIS JSON Integration Pack v2.5
Passes next URL suffix as encoded value for pagination settings.
SSIS JSON Integration Pack v2.3.1
SSIS JSON Integration Pack v2.3.1
Read complex JSON files, or a JSON formatted response from a REST API - just like reading a SQL table.

Prices from: $ 685.02

SSIS JSON Integration Pack is licensed by machine (Unlimited CPU and Users). A free Developer license with limitation of Visual Studio only development/testing is available. If you wish to run...

Got a Question?

Live Chat with our ZappySys licensing specialists now.

ZappySys
As official and authorized distributors, ComponentSource supplies you with legitimate licenses directly from ZappySys.
Compatible Containers
  • SQL Server 2017
  • SQL Server 2016
  • SQL Server 2014
  • SQL Server 2012
  • SQL Server 2008 R2
  • SQL Server 2008
  • SQL Server 2005
  • Visual Studio 2015
  • Visual Studio 2013
  • Visual Studio 2012
  • Visual Studio 2010
  • Visual Studio 2008