O'Reilly logo

Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide by Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

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

Perform the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required