- In this article i will be explaining the data flow components in ssis 2008 or 2012
- Data flow is the component of SSIS that focuses specifically on the movement and transformation of data within the package.
- There are three core components that can be used within the data flow:
Sources.
Sources extract data from data stores such as tables and views in relational databases, files and Analysis Services databases.
Destination.
Destinations load data into data stores or create in-memory datasets.
Transformations.
Transformations make modifications to the data as it is moved between a data source and a data destination.
The types of transformations that are available include:
- Data Formatting transformations to change the format of the data.
- Column transformations to copy, export or import columns.
- Multiple Data Flow transformations to merge, split or join data together.
- Custom transformations using .NET and ActiveX to perform custom transformations.
- Slowly Changing Dimension to manage dimension tables in a data warehouse.
- Data Analysis transformations such as data mining and Pivot for data analysis.
- Data Sampling transformations to perform row counts and sampling.
- Audit transformations to audit data changes.
- Fuzzy transformations to apply fuzzy logic to data within a transform to standardise data.
- Term transformations to extract specific data from text.
- Additionally, Integration Services provides paths that connect the output of one component to the input of another component.
- Paths define the sequence of components and let you add annotations to the data flow or view the source of the column.
|
0 comments:
Post a Comment