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:
Create a new SSIS package; name it
Transfer
Customer
Data
.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...