SSIS Integration Toolkit for HubSpot

Installation

To install and run SSIS Integration Toolkit for HubSpot, your system must have the following components installed.

A supported SSIS design-time or run-time

It can be one of the following:

• Azure-SSIS Integration Runtime (SSIS-IR)
• SSIS 2025
• SSIS 2022
• SSIS 2019
• SSIS 2017
• SSIS 2016
• SSIS 2014

Runtime

For SSIS run-time, the installation should use the corresponding SQL Server installation media, and you must select the "Integration Services" component during the installation, as shown below:

Note that when using SQL Server 2014, a cumulative update (preferably a recent service pack) is required to run our software during runtime. Otherwise, you may encounter some general .NET errors. 

Design-time

For SSIS design-time, you should install the following:

• The latest version of SQL Server Integration Services Projects Extension
• A supported Visual Studio version, such as Visual Studio 2026 or 2022

Note that Visual Studio should be first installed before installing the SSIS Project Extension. In addition, it is possible to work with an older version of the SSDT installation if you have saved a copy of the original download. However, we generally recommend using the latest SSIS Project Extension and a recent Visual Studio installation for best compatibility. 

Windows Operating System

Windows operating system requirements largely depend on the version of the SSIS runtime or design-time selected. We don't have any additional requirements in terms of the Windows operating system as long as it satisfies the minimum requirements of the SSIS runtime or design-time. The general guideline is that newer versions of the operating system tend to perform better. In summary, our software is compatible with the following Windows operating systems:

• For desktop systems (mostly for development workstations)
  • We generally recommend Windows 11 or greater.
    
  • Earlier versions of Windows desktop systems, such as Windows 10, 8.1, 8, or 7, should typically work if the general prerequisites are met. However, these versions are generally not recommended due to their support status with Microsoft.
    
• For server systems (mostly for runtime deployments)
  
  • We generally recommend Windows Server 2019 or greater (including Windows Server 2022, Windows Server 2025, and potentially future Windows Server versions).
    
  • Earlier versions of Windows Server operating systems, including Windows Server 2016 and Windows Server 2012, should work properly provided they satisfy the minimum requirements of the .NET Framework installation mentioned below. Please be mindful that those two versions are either approaching or have already reached their respective extended support, also known as end-of-life support.

.NET Framework

• • Our software requires the installation of .NET Framework 4.7.2 or above (including .NET Framework 4.8).

When you have confirmed that your system satisfies the necessary prerequisites, you can navigate to KingswaySoft's website at https://www.kingswaysoft.com to download the installation package.

After downloading the package, you can install the software by following the installation wizard.

Working with SSIS Toolbox

SSIS Toolbox is the first place that you will be looking for our components to be added to your ETL process during the design time.

Note: When working with SSIS Toolbox, you need to make sure that you are in the right view in order to see the right components. For instance, if you are looking for a data flow component, you need to make sure that you are in the Data Flow view, not the Control Flow view. Visual Studio would show different components depending on the design view that you are currently working with.

Once the data flow components are available in the SSIS Toolbox, you can start your ETL development by dragging them from the toolbox to the Visual Studio design surface.

Assigning Permissions

Note: This section only applies to v7.0 or prior versions.

The HubSpot Connection Manager retrieves tokens from the HubSpot app, once you give authorization. These tokens are then stored in the Registry so that once they have expired, our component will automatically request new tokens from HubSpot to minimize user effort, and replace the existing tokens with these new ones in Registry. In order to achieve this, there must be proper permissions given to the KingswaySoft folder in Registry.

Start by opening the Registry Editor, and navigate into the following folders:

• HKEY_LOCAL_MACHINE > SOFTWARE > KingswaySoft > SSIS Integration Toolkit for HubSpot
  

• Right-click on the SSIS Integration Toolkit for HubSpot folder in the KingswaySoft folder and select the Permissions option. Enable the following permissions to give yourself permission to modify this folder.