Surprise Me!

SSIS JSON File Source - Read JSON file or Web Service URL (REST, ODATA)

2016-04-04 6 Dailymotion

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

Buy Now on CodeCanyon