importing multiple text files into multiple tables using ssis

importing multiple text files into multiple tables using ssis

Q: I have multiple text files in a folder named xyz, and i have created a
new database in sqlserver which does not having any tables .Here my
problem is to import all those text files into new database according to
the text file named tables using ssis package .can anyone knows please
tell me the steps.
A: Step 1: Use foraech loop iterator to pick all files in the specific
folder. Step 2: By using script task get the column name from text file
and create the tables in you database. Keep the table name in the SSIS
variable. Step 3: Choose any destination task and insert the data into the
newly created tables.
I used foreach loop container and selected the path of text files .in step
2 am unable to write the script for the column import .i have couple of
text files named employee having columns id ,name and another one
department having deptno ,location . Actually am a beginner to sql server
and ssis too.can anyone knows please help me