Learn SQL Server Bi--etl design step by step

In this section, we mainly talk about my game transaction Data Analysis Project ETL (data extraction, loading, conversion) exactly how to do.

First of all, the next source system, because our main trading station server is not in the company, so can not directly from the source system directly extracted data. In fact, we already have a simple data analysis system, but this is the previous people do, not using sqlserver2005 bi platform to do, but directly write WinForm program to get. The original data extraction is the main station to provide exported Excel file over, and then to our side, import into our analysis library.

Well, in order to be simple, in fact, I just do a demo, for the future project preparation, so we extract data directly from the above has been the analysis of the database pumping, because the data structure is relatively similar, so the ETL process is relatively simple.

Let's take a look at the game dimension table first:

First, we'll create a new integration Services project.

Next, create a new IMPORTDIMGAMEPACKAGE.DTSX SSIS package.

Drag and drop a data Flow task onto the control flow panel (pictured)

Double-click the Data Flow task and come to the data flow panel

Then we drag the OLE DB source to the Data Flow panel, and double-click to edit it, create a new connection, and select the source data table to which you want to extract the data.