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 |
No comments:
Post a Comment