DTS Package

[SQLServer]

Is there any way I can output the result of a Master-Detail Query to a text file preserving the master-detail format within DTS? I need to include the count and the company info at the top of the file followed by each employee info.<br><br>Eg. I have two tables Company and Employees<br><br>My ouput text should looklike<br><br><br>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//Number of employees<br>Company A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//Company Name <br>James¦A¦<A HREF="mailto:James@Xyz.com">James@Xyz.com</A>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//Individual Data<br>Williams¦B¦<A HREF="mailto:Williams@zyz.com">Williams@zyz.com</A><br><br>Thanks in Advance<br>-GJK