You bet... what you want is the Data Conversion component. Stick it between your XML source and your SQL destination in your Data Flow, and you can convert Unicode to ASCII or vice versa.

Tim