Pre requisites:

Adapter service (select)

1) use the select adapter service to load database data into IS               

  Adapter service (select)

2) Use the service to map and transform the database data to xml DT

                Pub . XML .document to XML String

                                Adapter serv output – document

3) Use the service to output the resultant xml string to destination file

                Sample . IO . test . write to file