Another way of doing this is to import everything as a text into a staging table and transform it from there. This makes error/exception handling easier and generally makes the load faster. An added benefit is that one can have multiple transformation rules and checks which would be tedious at the best to code in SSIS.
😎