How to set up ASCII file for transfer to mainframe?

[majorbroncosfan]

Back on 2/21/01, a question was asked about transferring a file into a fixed ASCII file for a mainframe. I am now facing the same situation whereas a fixed ASCII file is being generated from DTS, but does not appear in the format being asked for. The fields are being padded where I have trimmed them and there are line breaks in the middle of the records.

For reference as to what type of problem I'm referring to, here is a copy of Frandezzo's request:

Hello all I have a little siutuation here. This is it - I have to generate a ANSI text file to send to somebody that is bascilly using a mainframe to store data. This is how they want me to format the text file -
Each transaction consists of 11 , Eighty byte records. They sent me a copy of the text file in the format that they want and it looks like this:
H101/04/200104051000016 01IPRXKPRPA2006ITIT JOHN SMITH
02 11 RIVERWIND DR. REXFORD NY
|
V
11 ETC.

And so on untill they get to the 11th record.

Now I know that when using DTS you can set it to use the Fixed Length as a delimeter. That is not a problem. Especilly that I set the lengths of my fields to be the same as the lengths of their fields. But how do I get the Records layed out like that format. As you know SQL server will return the records with all the field names at the top. How do I get them to list the way that they want:
01 John Smith
02 55 Main Street NY NY
03xxx@aol.com
04
05