I checked the error message you posted above and that is not very helpful. I've observed that sometimes the 'warnings' that preceed the 'errors' in the 'error list' tab in IS gives the pointer to the cause of the error.

So can you run the task in SSIS bids and if it error outs, copy the 'warnings' produced now instead of the errors?