As I mentioned, importing it to staging table and using trasform map will work.