Script JSON to Variables Task

Overview

Script task to bulk extract elements from JSON document into SSIS variables.

The input document should be a simple key-value pair where the key name will be the name of the variable where the value will be stored.

Example:

{
    varName1: varValue1,
    varName2: varValue2,
    varName3: varValue3,
    ...
}

Setup

The script has the following parameters:

• IsDocumentVariable - if true, the JSON document is stored in a package variable. Otherwise, it is file connection manager (Boolean).
  • DocumentVariable - the variable storing the JSON document. (String).
  • DocumentFile - JSON document file connection manager (FILE Connection).
• Transform - the transformation function to be applied to the JSON document before extraction. By default it returns the response unchanged.underscore.js functions are available by default. (String).