ssisdelimiterflat-file

SSIS - fields without the same number of characters causing space delimited file to push data to the next column


I am having a problem with a space delimited file I am uploading to SQL. This works as needed except there is a column which has occasional length differences which is separated by a space delimiter...

This is data viewer and the file

As you can see from the data viewer the column output from the flat file source is moving data across the columns.

I am using a space as a delimiter.

I would like to be able to have the data in the same columns even if the flight number is one less.


Solution

  • On this one I had to load each row as a whole rather than being able to separate into columns. I then took care of all the "heavy lifting" in SQL.