Search code examples
sql-serverssisssis-2012fixed-width

SSIS define EOL (or row delimiter)

This is a silly question but it is driving me nuts: why can't I define row delimiters in SSIS, just HEADER delimiters? Here is my situation: my file contains records of varying sizes: enter image description here

So, I am unable to define a row delimiter for my file. Further, I'm also unable to define the total row size (I am ASSUMING here that SSIS just adds up the column lengths defined in order to derive a total row length, but indeed there exists no independent one).

Here are all the settings available: enter image description here And as a result I am getting sparsely populated records (because the rows do not end where they should): enter image description here

Thank you so much in advance!

Solution

  • When your text file format is all fixed-width except for the last (right-most) column, you should use the Ragged Right format. It lets you specify widths for all columns except the last one, which uses the row delimiter instead.