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)