I deleted and added columns to an excel file, am using an excel source task, and I am getting this message. When I click on the Excel source, I get no message regarding an option to fix anything. When I add the external columns through the advanced editor, they are deleted the next time I try to go into it. Then I get the same message as before about columns out of sync.
I don't want to delete the task and then recreate it, but that might be the only way.
Also, the article from the last post does not help because the whole problem is the task is not fixing the errors and there is no way to force it as far as I can tell.
I have a destination table with more columns than are in my Excel worksheet. These are problem columns.