SSIS 2012 Data flow in Integration Services


Data flow in SSIS 2012 or 2008 Integration Services

  1. In this article i will be explaining the data flow components in ssis 2008 or 2012 
  2. Data flow is the component of SSIS that focuses specifically on the movement and transformation of data within the package. 
  3. 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.
  1. Additionally, Integration Services provides paths that connect the output of one component to the input of another component. 
  2. 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