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
Thanks,
Frandazzo
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
Thanks,
Frandazzo