Simple as this: in the Copy activity, use Polybase and on the sink tab uncheck "Use type default". That should do the trick.