This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(115.19999999999999, 94%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKW%3C/text%3E%3C/svg%3E)
I am trying to create a flat file export, the spec is fixed width column, no headers or delimiters. There are 16 columns, the total width of all the columns combined is 624 characters.
i have attempted two methodologies, both yield the same result where the exported text file reveals a ragged right file format.
The SQL is padding all columns using a REPLICATE function to pad columns and force datalengths
Method 1: Define Each column to spec, export
Method 2: Concatenate all columns, force 624 string length.
The format does not seem ragged to me, or more precisely there is nothing in the screenshot that stands out as ragged. What do I seem to see is that each line seem to have identation of some sort.
But it is difficult to tell without a spec of the desired format and an sample of an actual file.
Hi @Ken Wenze,
You may use Fixed width in the flat file connection manager editor like shown.
Regards，
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.
That's what I have, I tried using the row delimiter option too, same result