Data Flow Items

Data Flow:-

          It contains different Sources (to extract data from source), Transformations (Based on requirement we can modify the source data) and Target (To load data into target database)

• Data Flow Source
• Flat File Source
• OLE DB Source
• Excel Source
• ADO NET Source
• XML Source
• Raw File Source

•  Data Flow Transformations
• Aggregate
• Audit
• Character Map
• Conditional Split
• Data Conversion
• Derived Column
• Fuzzy Grouping
• Fuzzy Lookup
• Lookup
• Merge
• Merge Join
• Multicast
• OLEDB Command
• Row Count
• Slowly Changing Dimension
• Sort
• Union All
• Pivot
• Unpivot 

• Data Flow Destination
• Flat File Destination
• OLE DB Destination
• Excel Destination
• ADO NET Destination
• Raw File Destination