Building Data Flows

The Data Flow tab of the Package Designer is where you specify the details of any Data Flow tasks that you've added on the Control Flow tab. Data Flows are made up of various objects that you drag and drop from the Toolbox:

  • Data Flow Sources are ways that data gets into the system. Table 1 lists the available data flow sources.
  • Data Flow Transformations let you alter and manipulate the data in various ways.
  • Data Flow Destinations are the places that you can send the transformed data. Table 2 lists the available data flow destinations.

Source

Use

ADO NET

Extracts data from a database using a .NET data provider

Excel

Extracts data from an Excel workbook

Flat File

Extracts data from a flat file

OLE DB

Extracts data from a database using an OLE DB provider

Raw File

Extracts data from a raw file (proprietary Microsoft format)

XML

Extracts data from an XML file

Table 1: Data flow sources

Destination

Use

ADO NET

Sends data to a .NET data provider

Data Mining Model Training

Sends data to an Analysis Services data mining model

DataReader

Sends data to an in-memory ADO.NET DataReader

Dimension Processing

Processes a cube dimension

Excel

Sends data to an Excel worksheet

Flat File

Sends data to a flat file

OLE DB

Sends data to an OLE DB database

Partition Processing

Processes an Analysis Services partition

Raw File

Sends data to a raw file

Recordset

Sends data to an in-memory ADO Recordset

SQL Server Compact

Sends data to a SQL Server CE database

SQL Server

Sends data to a SQL Server database

Table 2: Data Flow Destinations


Mr. Ravi Krishna - Senior Software Engineer
I am a Mocrosoft ASP.net Developer and MCP Certified professional. I have overall 5 years of experience in IT Industry,in that 3 years experience in Microsoft BI(SSAS,SSIS,SSRS). I have experience on various business domains like Automation and Chemical.
https://sites.google.com/site/rkkumardotnet/
Read moreRead more about Contributor