I have a Table as the source and Table as the destination.
I get a can't convert between Unicode and non-Unicode after mapping the column when I over the destination.
I recall adding a data conversion task assigning the a Non- Unicode Data Type or is the other way around?