Sorry it has taken so long to get back to this, I really do appreciate the suggestion.

I tried the solution suggested, but it is still throwing the same error. I also tried making all of the destination columns nvarchar(max) with no success.