rob_nye - Thursday, February 23, 2017 2:11 AM
Importing into a staging table, like you did, is usually the best way to go because it allows you to pre-validate all data long before it hits your production table. It also makes doing "upserts" a whole lot easier, if that's something that you need to do.
--Jeff Moden
Change is inevitable... Change for the better is not.