Inserting a Header/Footer in an Exported Text File

Question:
Is it possible to count the number of records and, when that count is reached, insert a header/footer to an exported text file using VBScript in DTS? If so, where can I find examples?

Answer:
How about placing a HAVING COUNT <= MyValue on the end of the WHERE clause attached to an INSERT SELECT?

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: