Learn how to Read JSON Data in SSIS from RESTful Web Service or JSON Files.
For more info: http://zappysys.com/products/ssis-powerpack/ssis-json-file-source/
Features
◾Bulk extract/output JSON data from File
◾Bulk extract/output JSON data from Web Service Url (with OData REST API Support)
◾Support for reading JSON string or file/url path from SSIS Variable
◾Support for JSONPath expression
◾Support for looping through multiple files using wild card pattern (e.g. *.json).
◾Support for HTTP Request with Custom Headers (Useful when JSON is coming from REST API services where you supply credentials or API Key).
◾Support for very large JSON files
◾Support for SQL Server 2005, 2008, 2012, 2014 (32 bit and 64 bit)
