You're not providing quite enough information, what mechanism (not just ODBC) are you using to transport the data? A DTS/SSIS package? A piece of custom software?

Here's how you can use SQL Server's OpenJson function to dismantle JSON structures into relational tables targeting either transactional systems or data warehouses. JSON is great for moving data ...