Data Pack and Unpack components are SSIS components used to merge or extract data from a specified format.

There are currently 4 components available within this category:

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