1. I have Three different Structure of tables at source end.

2. I need a flat file from every table.(seperately)

3. I want write one package to satisfy all of the above.

example:

1.Type...

thanks......

thanks da_zero

i think this is a good idea i check it like this

move data from source to destination:

source = flatfie

destination = sql server table

but source (flat file)path available in one more flat file.

first i get the source file path and load...