Is there a way in SSIS 2008 to automatically convert Unicode strings to regular strings? Is there perhaps a package setting or something?
I am reading several Jet datbases and all the string fields are coming across as Unicode Strings and the destination table they are being inserted into are defined as regular strings.
I don't want to create a data conversion transformation for every string field in all these tables I'm importing.
I'm just hoping there is a property that states to treat unicode as the default code page of 1252.