About SSIS PowerPack

50+ drag and drop components for SSIS, integrate REST API, JSON, SOAP, XML, AWS, Azure, MongoDB, Big Data and many more.

SSIS PowerPack is a collection of 40+ 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, Redshift, DynamoDB, Google API (i.e. Analytics, Adwords), SOAP/Web API, Facebook, Twitter, ZenDesk and many more.

Why SSIS PowerPack?

  • 40+ coding free, drag & drop, high performance custom SSIS Components and Tasks.
  • Developed by team with over 15 years of experience.
  • Used by many around the globe (small to Fortune-500 companies).
  • Compatible with SQL Server 2005, 2008, 2008 R2, 2012, 2014 and 2016.
  • Support for 32bit and 64bit Server/Desktop OS.
  • Easy to use, familiar look and feel, fully integrated in BIDS/SSDT.
  • No license needed if you are developing/testing in BIDS/SSDT only.
  • Rapid update cycle. New components added every month.
  • Prompt support by experienced technology experts via live chat, phone, web meetings and email.

Integration scenarios covered by SSIS PowerPack
Here is the list of common scenarios you can achieve using SSIS PowerPack without coding.

  • REST API Integration.
  • XML Integration.
  • JSON Integration.
  • MongoDB Integration.
  • Microsoft Azure Cloud Integration.
  • Amazon AWS Cloud Integration.
  • Amazon DynamoDB Integration.
  • Amazon Redshift Integration.
  • Secure FTP Integration (SFTP, FTP/SSL, FTPS).
  • 3rd Party CRM/Online Services (e.g. Marketo, SurveyMonkey, Salesforce).
  • Various File Format Support (e.g. CSV, Excel, JSON, XML).
  • Automate/Schedule export/email process for SSRS Reports (Reporting Services).
  • Utility tasks for everyday things (e.g. File system, email, Zip/Unzip).

What’s included in SSIS PowerPack?

SSIS Tasks

  • Advanced File System Task.
  • Amazon DynamoDB ExecuteSQL Task.
  • Amazon Redshift Cluster Management Task.
  • Amazon Redshift Data Transfer Task.
  • Amazon Redshift ExecuteSQL Task.
  • Amazon Storage Task (Amazon S3).
  • Azure Storage Task (Blob Storage) (*Only for SSIS 2012 or higher).
  • Download File Task.
  • Export CSV File Task.
  • Export Excel File Task.
  • Export JSON File Task.
  • Export XML File Task.
  • JSON Parser Task.
  • Logging Task.
  • MongoDB ExecuteSQL Task.
  • Regex Parser Task.
  • Reporting Services Task (SSRS).
  • REST API Web Service Task.
  • Send HTML Email Task.
  • SFTP Task (Secure FTP, FTP/SSL).
  • Timer Task.
  • Validation Task.
  • XML Parser Task.
  • Zip File Task (Zip/Unzip Files).

SSIS Source Connectors

  • Amazon DynamoDB Source.
  • Azure Table Storage Source (*Only for SSIS 2012 or higher).
  • Dummy Data Source.
  • Google Analytics Source.
  • HTML Table Source (Web scraping).
  • JSON Source.
  • MongoDB Source.
  • XML Source.

SSIS Destination Connectors

  • Amazon DynamoDB Destination.
  • Azure Table Storage Destination (*Only for SSIS 2012 or higher).
  • MongoDB Destination.
  • Trash Destination.

SSIS Connection Managers

  • Amazon Redshift Database Connection Manager.
  • Amazon Storage Connection Manager (S3, DynamoDB, Redshift Cluster).
  • Azure Storage Connection Manager (*Only for SSIS 2012 or higher).
  • Google Data Connection Manager.
  • HTTP Connection Manager.
  • MongoDB Connection Manager.
  • OAuth Connection Manager (Connect to OAuth Services such as Facebook, Twitter, Google AdWords).
  • Secure FTP Connection Manager.
  • SMTP Connection Manager.