SSIS PowerPack

What is SSIS PowerPack?

The SSIS PowerPack is a collection of more than 70 high-performance drag-and-drop connectors/tasks for SSIS (i.e. Microsoft SQL Server Integration Services). SSIS PowerPack is designed to increase your productivity by using easy-to-use, uncoded components to connect many 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. Google Analytics, Google AdWords), API SOAP/Web,  Facebook, Twitter, Zendesk, eBay and more.

Why the SSIS PowerPack?

• Encoding, drag, and drop the high-performance set of custom SSIS components and SSIS tasks
• Used by many companies around the world
• Support for SQL Server 2017, 2016, 2014, 2012, 2008 (32/64 bits) and now Azure Data Factory
• Support for 32-bit and 64-bit operating system
• Easy to use, familiar appearance and fully integrated into BIDS/SSDT
• No license required if you are developing/testing on BIDS/SSDT
• Quick update cycle and immediate support with modern features.

Data Integration Categories

• File formats: JSON, XML, CSV, Excel
• Microsoft Azure Cloud
• Amazon AWS Cloud
• API SOAP/REST
• Secure FTP
• BigData/NoSQL (MongoDB, DynamoDB, Redshit...)
• E-mail and Reports
• Microsoft Dynamics CRM

System Requirements

• Net framework 3.5
• SSIS Runtime: To run the SSIS package, you will need one or more versions of SQL Server Integration Services 2005/2008/2008 R2 / 2012/2014/2016 or 2017
• Supported Client Operating Systems: Any OS is supported where you can install SSIS Client tools (e.g. Visual Studio). Tested product with Windows 7, Windows 8, Windows 8.1, Windows 10
• Supported Server Operating Systems: Windows Server 2003 / R2, Windows Server 2008 / R2, Windows Server 2012 / R2