Exporting multiple SQL tables to a single text file
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.
Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.