Installation and Setup

SSIS Integration Toolkit for Directory Services

Learn how to use the components found in this toolkit

Installation

To properly install and run SSIS Integration Toolkit for Directory Services, 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:

Integration Services Runtime Selection

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:

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.

download options

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

Installation

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

  • A supported SSIS design-time or run-time, which can be one of the following:
    • Azure-SSIS Integration Runtime (SSIS-IR)
    • SSIS 2025
    • SSIS 2022
    • SSIS 2019
    • SSIS 2017
    • SSIS 2016
    • SSIS 2014

    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:

    Integration Services Runtime Selection

    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. 

    For SSIS design-time, you should be installing the version of SSDT (SQL Server Data Tools) or BIDS (Business Intelligence Development Studio) that aligns with the SQL Server version that you plan to use for your final deployment (the runtime).

    Target Server Design Time
    Azure-SSIS IR Any one of the following:
    SSIS 2022 Any one of the following:
    SSIS 2019 Any one of the following:
    SSIS 2017 Any one of the following:
    SSIS 2016 Any one of the following:
    SSIS 2014 Any one of the following:
    • SSDT for Visual Studio 2019
      • Packages created using SSDT 2019 need to have their project's TargetServerVersion setting set to "SQL Server 2014" in order to work with SSIS 2014.
    • SSDT for Visual Studio 2017
      • Packages created using SSDT 2017 need to have their project's TargetServerVersion setting set to "SQL Server 2014" in order to work with SSIS 2014.
    • SSDT for Visual Studio 2015
      • Packages created using SSDT 2015 need to have their project's TargetServerVersion setting set to "SQL Server 2014" in order to work with SSIS 2014.
    • SSDT-BI for Visual Studio 2013

  • 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.

download options

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.

SSIS Toolbox Buttons

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 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.