I have a create an SQL statement that would out put the results to a text file.
That part is easy.
However I have been ask to have three levels in my text file
- File Header
- Detail Record
- File tail
So it has to look something like this.1111202366 File Header
2221053 105963138000100 671204555113SUPERMERCADO PAULISTA NOVA VENEZA LTDA Detail Record 3051120080000008344 File Tail
How do I create this ???
I am using SQL 2000 DTS jobs....I could get the data, I just do not know how to get all of it into the text file.