Possibly save 1 hour of your time: When you have a line in csv file that contains data with comma, the SSIS package may not parse it correctly.
i.e. country name, iso code, numeric code
“Bonaire, Saint Eustatius and Saba”,BES,535
You can use double quote to signify as text qualifier in the flat file connection manager.
This should parse as the fields correctly.