Yes, the Upsizing Wizard turns yes/no into bit.

However, the problem is, that the insert statement will not work, and I think if that statement can not be changed as pointed out you're pretty much out of luck