Installation and Requirements

You can install Devart SSIS Data Flow Components using one of the following methods:

•Installation wizard: Walks you through the installation process step-by-step in a guided interface.
•Command line: Installs and activates the Data Flow Components silently with default settings and no user interaction.

ExpandedToggleIcon        Requirements

Before installing Devart SSIS Data Flow Components, make sure that the following requirements are met:

•SQL Server Integration Services 2008, 2012, 2014, 2016, 2017, 2019 or 2022 (SSIS component) is installed.
 
Note: SQL Server Integration Services 2008 is not supported by Devart SSIS Data Flow Components for Dynamics 365.
•SQL Server Data Tools (SSDT) or BIDS 2008 (Business Intelligence Development Studio) are installed.  For the SSDT installation instructions, see Install SQL Server Data Tools (SSDT) for Visual Studio.
 
Note: BIDS 2008 is not supported by Devart SSIS Data Flow Components for Dynamics 365.
•Visual Studio 2019 or 2022 is installed.
•Internet connection is available.
•For Devart SSIS Data Flow Components for DB2: IBM DB2 .NET Data Provider is installed.

ExpandedToggleIcon        Install the Data Flow Components using the installation wizard

To install Devart SSIS Data Flow Components using the installation wizard:
 
1. Download and run the installer.

2. To start the setup process, click Next on the welcome page of the installation wizard.

wizard-welcome-page

3. Accept the license agreement and click Next.

license-agreement

4. Select the installation folder for the Data Flow Components.

installation-folder

5. Select the components you want to install.

select-components

6. Select the Start menu folder for the shortcuts, or keep the default location. Click Next.

select-folder-for-shorcuts

7. Review the installation settings, then click Install.

ready-to-install

8. After installation is completed, activate the Data Flow Components or continue without activation:

•To skip activation, click Next. This keeps the current license status.
•To activate manually, click Input, then enter activation key. To activate more than one products, separate the keys with semicolons (;).
•To activate using a file, click Load, then select the license file using the standard file dialog.

activate-license

Once a license is activated, its updated status is displayed on the License Information page:

license-activated

Click Next.

9. Click Install, then Finish to complete the installation.

setup-completed

CollapsedToggleIcon        Install and activate the Data Flow Components using the command line

To install and activate Devart SSIS Data Flow Components without user interaction, use one of the following modes:

•Silent: Displays the installation progress window, but requires no user input.
•Very Silent: Runs entirely in the background with no visible user interface.

Note: Before running the installer in one of these modes, make sure you have the activation key or a file that contains it.

 

Silent mode

To install and activate the Data Flow Components in Silent mode, open Command Prompt as an administrator. Navigate to the folder that contains the devartssis.exe file, and run the following command:

devartssis.exe /SILENT /activate=[activation-key | path-to-license-file]

Replace [activation-key | path-to-license-file] with your actual activation key or the full path to the license file.

silent-installation
 

Very Silent mode

To install and activate the Data Flow Components in Very Silent mode, open Command Prompt as an administrator. Navigate to the folder that contains the devartssis.exe file, and run the following command:

devartssis.exe /VERYSILENT /activate=[activation-key | path-to-license-file]

Replace [activation-key | path-to-license-file] with your actual activation key or the full path to the license file.

very-silent-installation

 

CollapsedToggleIcon        Verify the installation and activation

To verify that the Data Flow Components are installed and activated correctly, run one of the following commands from the activation utility folder. By default, the activation utility is located at: C:\Documents and Settings\All Users\Application Data\Devart\SSIS Data Flow\ssisactivator.exe.

 

Check the license status for all components

To view the license status of all installed Data Flow Components, run:

 

ssisactivator.exe -l

check-license-info-of-all-installed-products
 
Note: This command returns a list of all installed components along with their current license status.

 

Check the license status for a specific product

To view the license status of Data Flow Components for a specific product, run:

ssisactivator.exe -s -n [data-source]

Replace [data-source] with the name of the data source (for example, Salesforce or Oracle).

view-license-information-for-specific-product-after-installation

 

CollapsedToggleIcon        Add the Data Flow Components to the Toolbox

Depending on your SQL Server version, the Data Flow Components are added to the SSIS Toolbox automatically or need be added manually.
 
SQL Server 2012 - 2017

In Microsoft SSIS Designer, our Data Flow Components are added to the Toolbox automatically when you install Devart SSIS Data Flow Components. They are added to the Common tab of the Toolbox.

SQL Server 2008

In BIDS 2008 (installed with SQL Server 2008), Devart SSIS Data Flow Components are not added to the Toolbox by default.

To add our Data Flow Components to the Toolbox, perform the following steps:

1.Create an Integration Services Project.
2.Right-click in the Toolbox floating window to call its context menu and select Choose Items. The .Net Framework Components tab of the Choose Toolbox Items dialog is displayed; switch to its SSIS Data Flow Items tab.
3.Locate and select the corresponding Devart Source, Lookup, and Destination items, and click OK. Now these Data Flow Components are added to the Toolbox.
4.Drag the Data Flow Components to the corresponding Toolbox sections for further convenience.