thank you for your replay

i am new to ssis

can you elaborate what your saying

Hi Raunak,

Thanks for you r replay

i got u r point but where should i place the flatfile source and how can i give the table name to variable

please respond...

all the files are with .txt extension and having different structure

based on the file it destination should change.

thanks 🙂

all the files are .txt extension but different structure and they should be import to different tables.

sorry for my late response i out of the office for two days.

this is very helpful and good one

but i should not use the third party tools in my work i have the restriction.

but i am very thankful to you for your...

all these flat files are different from each other and destination tables are also different for every flat file

so now i got some idea like looping through the all the...

i gone through the u r example it is very helpful how to start but after getting the value into the filejustfound

how can i dynamically assign a file to...