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).
