I have 5 SQL tables set up that capture data that I need to export to a single text file.
The format of the file is as follows:
1st line is a File Header
2nd line is a Batch Header
3rd and subsequent lines are the transactional data lines
2nd Last line is a Batch Trailer
Last line is a File Trailer
Each of the line types have different fields with different vales.
Any clues would be much appreciated.