SQL Server 2019 Integration Service (SSIS)

SQL Server Integration Service (SSIS) enables its users to solve complex business problems. There have been multiple versions including new features and in this article the focus will be on the 2019 version. To learn more about SQL Server 2019 Integration service, its features, and earlier versions, read below.

What is SQL Server 2019 Integration service?

SQL Server Integration Services is a platform that allows users to build data transformations and enterprise-level data integration. It’s a substantial part of the Microsoft Business Intelligence (MSBI) stack, which is a type of application software that was designed by Microsoft to analyse, retrieve, report, and transform data for Business Intelligence. By using SQL Server 2019 Integration the following complicated business problems can be solved:

1. Loading data warehouses.
2. Cleansing and mining data.
3. Copying or downloading files.
4. Managing SQL Server data and objects.

SQL Server 2019 Integration Service: Requirements

To be able to install and use SQL Server 2019 Integration Service, there are several hardware and software requirements:

1. Minimum of 6 GB of available hard disk space.
2. Minimum of 4 GB memory.
3. At least Windows Server 2016 or Windows 10 TH1 1507.
4. Minimum 1.4 GHz with at least a 64-bit CPU.

SQL Server 2019 Integration Service: Features

These are the most relevant features of SQL Server 2019 Integration Service:

1. Smooth data integration from separate data sources.
2. Optimal integration with other Microsoft SQL product components.
3. Profiling and cleansing of data for better data quality.
4. API’s for SSIS object modelling.
5. Efficient high-speed data connectivity/integration implementation.
6. Organized lookup transformation and data mining query.
7. Master and meta data management.

SQL Server Integration Service: Versions

The first version of SSIS is called SSIS 2005 and replaced Data Transformation Services (DTS). The version after that was SSIS 2008/2008 R2. This version came with improved performance and new sources. After that SSIS 2012 was released. This upgrade made it possible for users to stall projects and packages to a server instead of the imitation that came with the prior individual packages. The version that came out after, SSIS 2014, didn’t include changes except new transformations and sources through SQL Server Feature Pack and CodePlex. SSIS 2016 is the next version and it includes an updated SSIS that allows users to locate whole packages, big data sources, and additional cloud. After that, SSIS 2017 came out. This version came with Integration Services on Linux and connectivity improvements. After that SSIS 2019 was released. All the important information regarding SQL Server 2019 Integration Service can be found in this article.

Is SQL Server 2019 Integration Service free?

To be able to install and use SSIS, users ned a SQL Server license. Users can either choose for Enterprise or Standard licensing, depending on what they would want to do with SSIS. The Standard version is usually sufficient but in some cases the Enterprise version is needed. So to install SSIS, users first have to purchase SQL Server. This means that in the case that users don’t have SQL Server already, installing SSIS wouldn’t be free since a payments is needed for SQL Server. However, for users that already own SQL Server, installing it is free since it comes with the license.