In response to your 2nd question.

"2. In the destination Table have the following columns. I must add the data from the flat file to my destination table and for each row i have to insert the flatfile name to column 'filename' to know the flat file source from which the data has come."

Have a look at using a variable to store your file name, you can then add this into your DataFlow by using the [Derived Column] Task. This will add the filename into the pipeline and will alow you to insert this information into your destination.

Cheers

-Matt