Don't use the source wizard and specify your data types? you should be able to get round it with that.

Allow your destination object to create the table once you have your data types correct (always name the component first to be the name of the table you want - saves creating the wrong table name when you forget to modify the script)

hope that helps