Exporting Data from JSON to CSV with SSIS

  • Daniel Calbimonte

    SSCarpal Tunnel

    Points: 4702

    Comments posted to this topic are about the item Exporting Data from JSON to CSV with SSIS

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Well put together, love the many graphics. Makes it easier to grasp.

  • sphoebus

    SSC Rookie

    Points: 25

    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?

    Thank you.

  • wratux

    Grasshopper

    Points: 13

    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?

    Cheers

  • Daniel Calbimonte

    SSCarpal Tunnel

    Points: 4702

    By the moment, there are third party solutions, but this may change in the future.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply