Using Integration Services for data transformation

SSIS have been part of the SQL Server since version 2005. A brief introduction to SSIS was written in Chapter 5, Data Transformation and Cleaning with T-SQL. Now we will jump deeper into one of the control-flow tasks, called Data Flow Task. The previous section showed us some of the data transformations used in data science. In this section, we will create a simple categorization of source data.

Setting up a SSIS project

First of all, we need to know which data we have as input. Here, we have two CSV files. One of them is named Products.csv, while the second is named Categories.csv. The Products.csv file contains a list of products with their names, list prices, and a CategoryID...