• This can be done

    by using Execute Process task all you need to do is

    Put CMD.EXE on the executable

    Put

    /C type headerfile.txt datafile.txt footer.txt > Your final file.txt ( this appends the header file records..data file records and footer file records to the final file

    put

    your working directory where all these files will be at ....

    where your header footer and data file is at ,

    and finally

    the results will be

    Header file data

    data file data

    and then the

    footer data ...