It might be easier to change the datatypes in the destination table.

You can also use the data conversion component. It's still manual, but at least you have a checkbox to select all the columns. 100 columns would take me 2 or 3 minutes.

Or you could write the data to a staging table having all unicode columns, and then transfer the data to the final destination table.