SSIS tutorial: How to extend with additional tasks (beyond the default Toolbox)

Tutorials SSIS Tutorials
1

Introduction

SQL Server Integration Services (SSIS) includes a default set of components in the Toolbox. However, these built-in tasks may not be sufficient when working with modern data sources such as REST APIs, cloud services, and SaaS platforms.

In this tutorial, we will show how to extend SSIS by adding additional tasks using ZappySys SSIS PowerPack. You will learn how to install the toolkit, how the Toolbox changes after installation, and what new connections and integrations become available.

Prerequisites

  • SQL Server Integration Services (SSIS)
  • Visual Studio (with SSIS extension installed)
  • Download and install the ZappySys SSIS PowerPack

Understanding the default SSIS Toolbox

By default, SSIS provides a limited set of components, such as:

  1. Data Flow Task
  2. Execute SQL Task
  3. Script Task
  4. File System Task

While these are useful for basic ETL operations, they do not provide native support for modern APIs, cloud services, or advanced data integration scenarios.

Default SSIS Toolbox
Default SSIS Toolbox443×645 92.2 KB

Installing ZappySys SSIS PowerPack

To extend SSIS capabilities, you can install ZappySys SSIS PowerPack:

  1. Download the installer from the official website
  2. Run the installation wizard
  3. Restart Visual Studio after installation
  4. After installation, new components will be automatically added to your SSIS Toolbox
  5. If you do not see the components in the Toolbox, refer to this article

Exploring the extended SSIS Toolbox

Once installed, you will notice several new components added to the Toolbox in the Control Flow, including:

  1. ZS Advanced File System Task
  2. ZS Amazon DynamoDB / Redshift / S3 / Blob Storage Task
  3. ZS Download Task
  4. ZS Export CSV / JSON / Excel / XML Task
  5. HTML Email Task
  6. ZS JSON / XML Parser Task
  7. ZS MongoDB / PostgreSQL Execute SQL Task
  8. ZS REST API Task
  9. ZS Salesforce API Task
  10. ZS Secure FTP Task
  11. ZS Validation Task
  12. And many more

SSIS components - Control Flow
SSIS components - Control Flow253×632 24.8 KB

Inside the Data Flow, you will find:

  1. ZS Amazon Source / Destination
  2. ZS Azure Source / Destination
  3. ZS API Source / Destination
  4. ZS Cosmos DB Source / Destination
  5. ZS CSV Source / Destination
  6. ZS XML Source / Destination
  7. ZS Excel Source / Destination
  8. ZS Dropbox Source / Destination
  9. ZS Dynamics Source / Destination
  10. ZS ElasticSearch Source / Destination
  11. ZS Google Ads Source / Destination
  12. ZS Google Analytics Source
  13. ZS Google BigQuery Source / Destination
  14. ZS Google Drive Source / Destination
  15. ZS Google Sheets Source / Destination
  16. ZS HubSpot Source / Destination
  17. ZS HTML Table Source
  18. ZS Jira Cloud Source / Destination
  19. ZS JSON Source / Destination
  20. ZS MongoDB Source / Destination
  21. ZS Power BI Source / Destination
  22. Outlook Mail Source / Destination
  23. ZS Salesforce Source / Destination
  24. ZS SharePoint Source / Destination
  25. ZS Smartsheet Source / Destination
  26. ZS XML Source / Destination
  27. ZS Zendesk Source / Destination
  28. ZS Zoho Source / Destination
  29. ZS Zoom Source / Destination
  30. Web API Destination
  31. Upsert Destination
  32. And many more

SSIS components - Data Flow
SSIS components - Data Flow776×792 119 KB

These components allow you to connect SSIS with modern systems without writing custom code.

And within our API Source/Destination, we have more connectors. Here is an example

API Source / Destination connectors
API Source / Destination connectors868×775 29.4 KB

What you can connect to

With the extended Toolbox, you can integrate SSIS with a wide range of systems:

  1. REST APIs (e.g., CRM, ERP, SaaS platforms)
  2. Cloud services (Azure, AWS, Google APIs)
  3. Databases (SQL Server, PostgreSQL, Redshift)
  4. File formats (JSON, XML, Excel, CSV)
  5. Applications (Salesforce, HubSpot, Mailchimp, and more)

This enables you to build modern ETL pipelines directly inside SSIS. ZappySys continuously adds new connectors. In version 6.0.0.10308 (Mar 03, 2026), new components were introduced for services such as Google APIs, Power BI, Cosmos DB, Jira, and Zoom.

Example use cases

Here are some common scenarios enabled by the extended Toolbox:

  1. Extract data from REST APIs and load it into SQL Server
  2. Synchronize cloud data with on-premise databases
  3. Send automated HTML emails with query results
  4. Perform upsert (insert/update) operations without writing custom SQL
  5. Transform JSON or XML data into a relational format

Conclusion

The default SSIS Toolbox is designed for traditional ETL scenarios, but modern data integration requires connectivity to APIs and cloud platforms.

By installing ZappySys SSIS PowerPack, you can significantly extend SSIS capabilities, enabling seamless integration with modern data sources while reducing the need for custom scripts or complex coding. Download and install it to start building smarter, faster, and more scalable solutions.

Still need help?

If the issue persists, please get in touch with our support team: