JSON & XML Processing components are SSIS components used to interact with JSON or XML data.

There are currently 8 components available within this category:

  • JSON Source
    • An SSIS source component used to retrieve JSON documents from HTTP requests or files and extract them into column data
  • JSON Merge
    • An SSIS transformation component used to merge input data into JSON.
  • JSON Extract
    • A transformation component which extracts data from JSON documents to enable the use of using JSON as a source within SSIS.
  • JSON Destination
    • An SSSIS destination component used to merge input data into JSON and output it to a file or send an HTTP request.
  • XML Source
    • An SSIS source component used to retrieve XML documents from HTTP requests or files and extract them into column data.
  • XML Merge
    • An SSIS transformation component used to merge input data into XML.
  • XML Extract
    • An SSIS transformation component used to extract column data from XML documents to use the data as an SSIS source.
  • XML Destination
    • An SSIS destination component used to merge data from input columns into an XML document and output it to a file or send an HTTP request that uses the XML document in it's body.