SSIS Data Flow Task

SSIS Data Flow Task: Data Flow Task is used to move data between Source and Destination. It also provide other sub-tasks to Transform and Modify the source data. Following are the main activities performed by a data flow task:

1. Connect to Source (Excel, Raw File, Text File, XML File, Database Servers)
2. Bring Data from Source.
3. Transformed Source data if required.
4. Connect to Destination (Excel, Raw File, Text File, XML File, Database Servers)
5. Load the data in destinations.

Here is a step by step guide to create a simple package including a data flow task for Pulling Data from a text file to a database table.

Your valuable comments will be highly appreciated.