Flat File And Uneven Number Of Columns

Please leave feedback for Microsoft regarding this problem at https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=126493



Ok I'm sure it just me, SSIS has been great so far....but how can you import a straight CSV file with and uneven column count.

For example: (assume CR LF row delimiter)

The,Quick,Brown,Fox,Jumps
Hello,World
This,is,a,test

"Normally" I'd expect this




| Col1 |
| Col2 |
| Col3 |
| Col4 |
| Col5 |

The
Quick
Brown
Fox
Jumps

Hello
World
NULL
NULL
NULL

This
is
a
test
NULL

Ok but what we get is the row delimiter is ignored in preference for the column delimiter and the row delimiter gets sucked into the column and the next row starts to get layed down.

So we get




| Col1 |
| Col2 |
| Col3 |
| Col4 |
| Col5 |

The
Quick
Brown
Fox
Jumps

Hello
World{CR}{LF}This
is
a
test

I'm I not seeing a tick box somewhere that says "over here if you want to terminate a row on the row delimiter even if all columns aren't full and we'll pad NULLs in rest of the row columns which you can fix in the flow transformations"

I'm sure it's there.....help!

(By the way SSIS team, great job on the package love using it)