Where, exactly, did you try to change change the codepage?
I'm not logged in to SSIS at the moment, so can't give you exact details, but you need to start off with your connection manager and work forward from there. Use the 'Advanced Editor' where available, to check the codepage property at every stage through the pipeline.