Installation and Requirements

Requirements

Prior to 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. (SQL Server Integration Services 2008 are not supported by Devart SSIS Data Flow Components for Dynamics 365)

•	SQL Server Data Tools or BIDS 2008 (Business Intelligence Development Studio) are installed. (BIDS 2008 is not supported by Devart SSIS Data Flow Components for Dynamics 365)

•	Internet connection is available.

•	Visual Studio 2019 or 2022

•	Devart SSIS Data Flow Components for DB2 requires IBM DB2 .NET Data Provider to be installed on your computer.

To verify that SQL Server Integration Services component and Microsoft SQL Server Integration Services Designer are installed, run SQL Server Data Tools from the Start menu -> Microsoft SQL Server , then on the File menu click New -> Project. This will display the New Project window; locate the Installed templates area and make sure that it contains the Business Intelligence -> Integration Services item.

Installation

To install Devart SSIS Data Flow Components, download the installer from Devart Downloads page.

Run the downloaded installer and follow the instructions in the wizard.

SQL Server 2022

For successful Devart SSIS Data Flow Components setup, you need to download the SQL Server Integration Services Projects extension for Visual Studio 2022. You should download and install this extension prior to installing Devart SSIS Data Flow Components. You can get it in the following way:

1.	In Visual Studio, in the Extensions menu, select Manage Extensions...

2.	In the Extension Manager dialog box, enter 'Integration Services' in the Search box.

3.	Select the SQL Server Integration Services Projects 2022 extension and then click Install. This will download the Microsoft DataTools installer (Microsoft.DataTools.IntegrationServices.exe).

4.	Run the downloaded installer.

5.	Select the installer language and click OK.

6.	Click Next.

7.	Select the Visual Studio instance to install the extension to and click Install. Wait for the installer to complete.

8.	Click Close.

After this, you will be able to create Integration Services projects in Visual Studio 2022.

SQL Server 2019

For Visual Studio 2019, you need to download the SQL Server Integration Services Projects extension for Visual Studio. You need to download and install this extension prior to installing Devart SSIS Data Flow Components. You can get it in the following way:

1.	In Visual Studio, in the Extensions menu, select Manage Extensions.

2.	In the Manage Extensions dialog box, enter 'Integration Services' in the Search box.

3.	Select the SQL Server Integration Services Projects extension and then select Download. This will download the Microsoft DataTools installer (Microsoft.DataTools.IntegrationServices.exe).

4.	Run the downloaded installer.

5.	Select the installer language and click OK.

6.	Click Next.

7.	Select the Visual Studio instance to install the extension to and click Install. Wait for the installer to complete.

8.	Click Close.

After this, you will be able to create Integration Services projects in Visual Studio 2019.

SQL Server 2012 - 2017

In Microsoft SQL Server Integration Services Designer, our 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 install 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. .Net Framework Components tab of the Choose Toolbox Items dialog box 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 components are added to the toolbox.

4.	Drag them to the corresponding toolbox sections for further convenience.