Post reply

How to import json from http request into SQL table by using SSIS 2008

  • January 13, 2017 at 9:46 pm

    #1922726

    Oh jeez, didn't realize how old this post was. Man, the necromancy in this thread is strong.

  • January 13, 2017 at 9:52 pm

    #1922727

    foxr4 - Wednesday, January 11, 2017 5:14 PM

    There's a bug importing csv files, and it's not flexible.I can convert xls to json with nodejs and 2 lines of code. Now if i could import json to sql, that would be ideal.I guess I can make a driver, but I am sure it's been done.

    There are several articles out there for splitting it in SQL Server itself, for example
    http://www.sqlservercentral.com/articles/JSON/68128/

Viewing 2 posts - 16 through 16 (of 16 total)

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