• OK - but I asked about the column names and I'm not sure that you've tried what I suggested.

    In your SQL for the extraction from the view, try aliasing the columns with spaces so that they have no spaces as far as SSIS is concerned:

    [Cost Rate] CostRate,

    [Line Item Status] LineItemStatus,

    etc etc

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.