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.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
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.