New answers tagged etl
Figured it out shortly after posting. Although SSIS doesn't allow you to delete the error columns in the error output of the first insert, it does allow you to change the names. I was able to modify the names of these columns and then the Union does not throw any errors as the names are not in conflict anymore.
Top 50 recent answers are included