Creating a simple ETL package

This recipe will show you how to build a simple ETL package that does the following:

• Extract data from the AdventureWorksLT SalesLT.Customer table.
• Transform data: Concatenating all customer-name-related information into a single column called FullName.
• Load the data into a new table called SalesLT.CustomerFullName.

The table we create will be used in the final recipe in this chapter, Loading data before its transformation, to explain ELT.

Getting ready

This recipe assumes that you have installed SSMS, Visual Studio 2019, and SSIS.

How to do it…

Let's begin by opening Visual Studio 2019:

1. Select Create a new project from the main screen.
2. Select Integration Services Project from the screen that appears, as shown in the following screenshot:

   Figure 2.16 – Visual Studio – creating a new Integration Services Project

3. As shown in the following screenshot, name the project AdventureWorksETL...