Comments posted to this topic are about the item Exporting Data from JSON to CSV with SSIS
Well put together, love the many graphics. Makes it easier to grasp.
I thought SSIS was going to have built-in support for JSON as a datasource, but I see you are downloading a component from Codeplex to complete this task. Is this component preferred over what SSIS offers or will offer?
I didn't know you could do this with SSIS, in the past I used this tool to flatten and import JSON data: convert JSON to CSV
Maybe using this makes more sense when you have more complex data?
By the moment, there are third party solutions, but this may change in the future.
Viewing 5 posts - 1 through 4 (of 4 total)