JSON Source SSIS Plugin 1.0

JSON Source SSIS Plugin is a data flow source component for Microsoft SQL Server Integration Services that makes it easy to bring JSON data into your ETL pipelines without custom scripting. It connects to files, web APIs, and other JSON endpoints, then flattens hierarchical structures into tabular columns you can map and transform inside SSIS.

Key features:

• Connect to JSON from files, HTTP/S endpoints, and SSIS variables
• Flatten nested objects and arrays with a visual path/field selector
• Infer a schema automatically or define explicit mappings for full control
• Handle pagination (page/offset, cursor/next-link patterns) for large API datasets
• Support common authentication methods (API keys, Basic, OAuth 2.0) and custom headers
• Configure retries, timeouts, rate limiting, and proxy settings for resilient loads
• Redirect or log bad rows with detailed error messages for easier troubleshooting
• Preview responses and test queries before running full data flows

Typical use cases include loading REST API data into SQL Server, normalizing complex JSON into relational tables, and blending API responses with on-premises data. If you build SSIS packages that touch modern APIs or JSON files, this plugin helps you do it faster and more reliably.

JSON Source SSIS Plugin is developed by Webkingsoft. The most popular version of this product among our users is 1.0.

You can check Source Insight, SHOUTcast Source DSP Plug-in, SSIS Integration Toolkit for Microsoft SharePoint and other related programs like SSIS Productivity Pack at the "download" section.