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 ...
Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
