Time for action – loading customer information from a flat file into a database table with a Data Flow Task

In this section, we will go through an example of fetching information from a CSV file that contains customer information. Then, we will apply a simple transformation to calculate the age of a customer based on their birthday, and finally, we will load the result set into a database table. For this example, we will use a Data Flow Task with Flat File Source, Derived Column Transformation, and OLE DB Destination. The following screenshot shows data rows in the Customers_2.csv file, which need to be transferred to a database table:

Perform the following steps to load the information into a database table:

1. Create a new SSIS package; name it Transfer Customer Data.

2. Create the destination table for this example by running the following script on the Packtpub_BI_2014 database:

   CREATE TABLE [dbo].[Customer](
     [CustomerKey] [varchar](50) NULL,
     [GeographyKey] [varchar](50) NULL,
     [CustomerAlternateKey...