ssisdelimiterflat-file

SSIS - Unable to delimit a text file with space delimiters


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 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.