This allows the good rows to be loaded and the bad rows to be logged for later review. Also, keep in mind that you can log to any of the available destinations in SSIS.

However, even without a JSON datatype, SQL Server 2016 still lets you query data stored in JSON format. I’ll look at that support in a later column (among other features, it provides a way to ...