I'm sorry for your loss, Steve.

This is excellent advice to think about. I appreciate your thoughtfulness in putting together this editorial.

• This reply was modified 4 years, 4 months ago by  tulenkog.

Nope - I knew it was something really dumb. Thanks for your help!

The first destination column is char(11)

and there are a number of varchar columns as well:

varchar(50)

varchar(50)

varchar(25)

I'm using a Data Conversion transformation and setting each of these Data Types to:

string[DT_STR] with Code...

And when the data conversion component doesn't work, what else can you try?

(still comes back with "cannot convert between unicode and non-unicode string data types")