Read a csv file that has a JSON column in SSIS?

You can use a script component to process the JSON into its own detail table.

I created the following dataflow:

Here are the steps to the script component:

On inputs add ID and Address columns:

On inputs and outputs: add a new output and create columns (remember to program the datatypes:

The script:

public class Addresses
{
    public int address_line_1 { get; set; }
    public string post_code { get; set; }
}

public override void Input0_ProcessInputRow(Input0Buffer Row)
{
    //Test if addresses exist, if not leave the Row processing
    if (string.IsNullOrEmpty(Row.addresses)) return;        

    //Fix Json to make it an array of objects
    string json = string.Format("[{0}]", Row.addresses);

    //Load into an array of Addressses
    Addresses[] adds = new System.Web.Script.Serialization.JavaScriptSerializer().Deserialize<Addresses[]>(json);

    //Process the array
    foreach (var a in adds)
    {
        rowsAddressesBuffer.AddRow();
        rowsAddressesBuffer.ID = Row.id;
        rowsAddressesBuffer.Address1 = a.address_line_1;
        rowsAddressesBuffer.PostalCode = a.post_code;
    }
}

Notes:

1. The class added to store results.
2. The JSON had to be fixed to create an array of objects.
3. You need to add a reference to System.Web.Extensions.
4. This goes to the load. Make sure text qualifier is defined as a double quote (")