Bushra Anjum

My feedback

  1. 98 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  4 comments  ·  Azure Synapse Analytics » SQL/Loading  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Bushra Anjum commented  · 

    Try the following ":
    https://zappysys.com/products/ssis-powerpack/ssis-json-integration-pack/

    Here you can see following features :

    =>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 (see)
    =>Parse source JSON String/Documents into multiple columns/rows.
    =>Ability to de-normalize nested JSON data into flat structure
    =>Create simple or nested JSON documents inside DataFlow Task using simple drag and drop approach
    =>Ability to create nested JSON from Multiple datasets
    =>Ability to create single JSON document for all input records or create one document for each input row from ROOT dataset
    =>Export multiple tables/views to JSON files (e.g. Sales% or do SalesJan|SalesFeb)
    =>Export SQL query output to JSON file
    =>Inbuilt Layout Editor for creating complex JSON with nested structure (Document Array, Value Array, Nested attributes
    =>Automatically Split exported JSON data into multiple files by Size or Number of records
    =>Automatically Split exported JSON data into multiple files by Split By Column (e.g. SplitBy=Country will create new file for each country)
    =>Support for SQL Server 2005, 2008, 2012, 2014, 2016 and 2017 (32 bit / 64 bit)

Feedback and Knowledge Base