Data Integration Made Easy

Field Mapping from Nested Documents

The component displays a hierarchical view of your JSON or XML source, allowing you to select nodes with precision. You can choose fields to output, rename them, and define their data types. Reuse your configurations across pipelines by importing or exporting document layouts.

JSON Extract Editor interface showing data nodes and settings

Increased Efficiency

Get Structured Data from Complex Formats

Easily extract structured outputs from nested records and table-based sources using a visual editor built for SSIS workflows. The component supports web-based and file-based formats, offering field-level control during extraction. You can define output schemas, rename and validate fields, and apply filters to shape your data. Ideal for document and web sources that require structured delivery for downstream processes such as data warehousing and analytics integration.

Document Workflow Integration

Move data across connected platforms
Document Source
Usage
JSON from REST APIs
Extract nested records and shape into flat tables
XML from business systems
Transform and route data into storage or analytics
Mixed-format integrations
Handle variable structures with reusable mappings

Use Across Document Workflows and Platforms

KingswaySoft

JSON & XML Processing Components

SSIS JSON Connector
JSON
SSIS XML Connector
XML
SSIS HTML Table Source Connector
HTML Table Source
SSIS Productivity Pack

Enable Complex Data Processing

Support document-style inputs, online data, and semi-structured formats
with components designed for flexible, high-volume integration work.

DownloadPurchaseHelp Manual

Familiar UI

A performant and flexible ETL platform

Our solution is built utilizing Microsoft SQL Server Integration Services (SSIS), allowing your team to take advantage of the technologies and skills they already have. The drag-and-drop user interface makes it easy to set up powerful integrations within a matter of minutes.

Data flow diagram showing REST destination, error handling, and DataReader destinations.

More Resources

Download our Data Sheet for
SSIS Productivity Pack

SSIS Productivity Pack Data Sheet