Pre requisites:

Adapter service (for selecting/fetching data from database)

Flat file Dictionary

Flat file schema

Flat file schema DT

 1) Use    Adapter service (for selection)

2)   Map step from database to Flat DT

                      Adapter service output – flat schema DT

3) Use the service to transform Flat DT to a string

              Pub . flat file . convert to string

Map:

                                     Flat schema DT  -  flat file values

                                     Flat file schema  - path

4) Use the service to output the result to destination file

              Sample . IO . test . write to file