 |
ZappySys develops tools and connectors for Microsoft Business Intelligence, Azure, Amazon AWS, MongoDB and more... We provide everyday tools to make developer life easy. Check outour products including many FREE tools. If you are an MVP you may qualify for FREE MVP License |
SSIS Export Excel File Task
SSIS Export Excel File Task is your one stop solution to create excel reports/workbooks from SSIS. You don’t need any drivers, no need to worry about metadata issue you face with native SSIS Excel Task. We worked hard to take care most painful tasks for exporting data from any relational source to Excel.
Features
- Export multiple tables/views to Excel files (e.g. Sales% or do SalesJan|SalesFeb)
- Export SQL query output to Excel file
- Completely dynamic approach without limitation of DataFlow Stict Metadata
- Option to export data to specific starting location in Excel Sheet (e.g A5 will start writng to 5th row 1st column)
- Support for Password protected excel file
- Option to clear range of cell before writing data to existing excel workbook (e.g. A1:D5000 will clear A to D columns from 1st to 5000 rows)
- Automatically Split exported Excel data into multiple files by Size or Number of records
- Automatically Split exported Excel data into multiple files or tabs when Split By Column (e.g. SplitBy=Country will create new file for each country, if SplitOnTab option specified then data written to new excel tab rather than file for each new group)
- Support for Compression and Append
- Fully managed means works out of the box on 32-Bit and 64-Bit without any change (Native SSIS Excel functionality is 32bit only).
- Support for SQL Server 2012, 2014, 2016, 2017 and 2019 (32 bit / 64 bit)
Screenshots
 |
SSIS PowerPack is a collection of 70+ high performance, drag and drop connectors/tasks for SSIS (i.e. Microsoft SQL Server Integration Services). SSIS PowerPack is designed to boost your productivity using easy to use, coding-free components to connect many cloud as well as on-premises data sources such as REST API Services, Azure Cloud, Amazon AWS Cloud, MongoDB, JSON, XML, CSV, Excel, Salesforce, Redshift, DynamoDB, Google API (i.e. Analytics, AdWords), SOAP/Web API, Facebook, Twitter, Zendesk, eBay and many more.
SSIS PowerPack also includes high quality FREE commercial components and tasks with full support/upgrade
Click here to read more ...
|
Why SSIS PowerPack?
- Coding free, drag & drop high performance suite of Custom SSIS Components and SSIS Tasks
- Used by many companies around the globe
- Easy to use, Familiar looks and feel and fully integrated in BIDS/SSDT
- No license needed if you are developing/testing in BIDS/SSDT
- Rapid update cycle and prompt support (See what's new). We will help you over phone, web meetings and via email.
- 30 days money back guarantee if not satisfied for whatever reason.
Data Integration Categories
| |
