Home » SSIS PowerPack » SSIS Components » SSIS Excel Destination

SSIS PowerPack v2.9.5 released (Maintenance Release)

Posted on June 25, 2019June 25, 2019 by ZappySys

What’s New In this release we focused on fixing some bugs with Dynamics CRM Source , Dynamics CRM Destination and Reporting Services Task. Version 2.9.6.10621 [Jun 24, 2019] New Features/Improvements NEW: Excel Source – Add option to read from any sheet by number rather than hard coded table name (e.g. $4$ , $5$ … ) Bug fixes […]

Create Excel File in SSIS (Read from JSON / XML)

Posted on March 23, 2019September 11, 2019 by ZappySys

Introduction In this post, we will learn how to Create Excel File in SSIS from source like JSON / XML. We will use SSIS PowerPack to connect and query a JSON or XML file. This article also covers creating Excel from JSON File. JSON stands for JavaScript Object Notation and it is an Open and Standard format to […]