1. Extract data from flat file to sql table

                        Extract data from flat file to sql table

steps:-

1.       In Control flow take one data flow task from tool box.

2.       Double click that and take one flat file source tool.

3.       Double click that and make new connection and browse  text file .

4.       Take one OLE DB Destination tool , double click it    and make new connection with database

5.       Select table  then  ok.

6.       Run package your data inserted into table.