I have made some recent changes since the first screenshot.

Such as making sure there are no spaces in the excel csv files, that they are all equal length and

making sure the ole db destination datatype is DT_STR etc.

and even though it no longer says error and now says 'warning & information messages'....

it does not write anything to my database table at all.