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.

SQL Server 2016 and Azure SQL Database both give you tables that automatically keep track of the history of ... SQL Server adds time-based columns to the two tables specifying when each row was the ..

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 ...