1

I have a flat file connector in SSIS but for some reason it is not splitting the commas into columns. I have the column delimiter set to comma and you can see in "Column 0" there is commas "," however it just doesn't want to split them. Has anyone come across this before? Any help would be amazing!

The file has a LF line terminators (UNIX way). Is this an issue for SSIS? There is an option I have selected.

enter image description here

user2407147
  • 1,508
  • 2
  • 22
  • 40
  • 1
    Is there a text qualifier set? e.g. double-quotes will delimit a string containing commas ("some, random, text") so that the string between the double-quotes will be treated as a single value. – MJH Mar 24 '18 at 22:04
  • There is no text qualifier set however even adding a double quotes to the text qualifier box does not fix the issue :/ – user2407147 Mar 24 '18 at 22:47
  • Have you opened the source file to verify it's in the correct format? There seems to be two blank rows and then some text like 'something Fields' in the image in the question. – MJH Mar 24 '18 at 22:59
  • Yes, it is definitely formatted correctly, when I open in excel, it looks fine :S – user2407147 Mar 24 '18 at 23:25
  • Is it an excel document then? Try exporting it from excel into a tab delimited file and import that. – MJH Mar 24 '18 at 23:32
  • No, it is a CSV file. Need it to be automated as i'll be using foreach loop containers – user2407147 Mar 24 '18 at 23:35

1 Answers1

0

I've found the solution, needed to remove a few rows to get the headers to split, using the "Header row to skip" entry. Thanks for all your help!

enter image description here

user2407147
  • 1,508
  • 2
  • 22
  • 40