Hosted by Dailymotion. For legal issues report at the Copyright Center, report us on DMC, or use the Instant Removal tool.
SSIS JSON Export Task - Generate JSON file from SQL Server, MySQL or Oracle Tables
Description
Generate JSON file from relational Database such as SQL Server, MySQL, Oracle in few clicks.
For more info: http://zappysys.com/products/ssis-powerpack/ssis-export-json-file-task/
◾Export multiple tables/views to JSON files (e.g. Sales% or do SalesJan|SalesFeb)
◾Export SQL query output to JSON file
◾Inbuilt Layout Editor for creating complex JSON with nested structure (Document Array, Value Array, Nested attributes
◾Automatically Split exported JSON data into multiple files by Size or Number of records
◾Automatically Split exported JSON data into multiple files by Split By Column (e.g. SplitBy=Country will create new file for each country)
◾Support for Compression and Append
◾Create Multi content JSON documents
◾Support for SQL Server 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit)
For more info: http://zappysys.com/products/ssis-powerpack/ssis-export-json-file-task/
◾Export multiple tables/views to JSON files (e.g. Sales% or do SalesJan|SalesFeb)
◾Export SQL query output to JSON file
◾Inbuilt Layout Editor for creating complex JSON with nested structure (Document Array, Value Array, Nested attributes
◾Automatically Split exported JSON data into multiple files by Size or Number of records
◾Automatically Split exported JSON data into multiple files by Split By Column (e.g. SplitBy=Country will create new file for each country)
◾Support for Compression and Append
◾Create Multi content JSON documents
◾Support for SQL Server 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit)
More from User
06:38
SSIS Export Excel Task - Generate excel Dynamically
Zappysys
11:30
Query/Read data from Amazon DynamoDB Table, Write JSON documents into DynamoDB
Zappysys
06:07
SSIS JSON Export Task - Generate JSON file from SQL Server, MySQL or Oracle Tables
Zappysys
05:18
SSIS MongoDB Source - Use SQL Like Query Language for reading MongoDB Collection
Zappysys
13:45
SSIS HTML Table Source - Web scraping without coding from any URL
Zappysys
07:40
SSIS MongoDB Destination - Generate and load JSON Documents into MongoDB Collection
Zappysys
Related Videos
07:37
SSIS Export SQL Server Data to CSV Flat File
KatieAndEmil
12:49
SQL Server BI || MSBI(SSIS, SSAS, SSRS) Training From SQL School
SQLSchool Training Institute
08:22
SQL Server Integration Services (SSIS) Web Crawling Scrapping Part 1
Sylvan Autry
00:38
Full version Extending Ssis with .Net Scripting: A Toolkit for SQL Server Integration Services
Gilbertergtu
05:08
SSIS Google Analytics Source - Read data from Google Analytics Platform and load into SQL Server
Zappysys
07:17
SSIS Import CSV file into SQL Server table
KatieAndEmil