locked
Load Json File using script component - 2014 sql server RRS feed

  • Question

  • Hi,

    Please help me load the Json File into SQL server by parsing using .net

    {
         "firstName": "John",
         "lastName": "Smith",
         "age": 25,
         "address":
         {
             "streetAddress": "21 2nd Street",
             "city": "New York",
             "state": "NY",
             "postalCode": "10021"
         },
         "phoneNumber":
         [
             {
               "type": "home",
               "number": "212 555-1234"
             },
             {
               "type": "fax",
               "number": "646 555-4567"
             }
         ]
     }

    Thanks

    • Moved by Bob Beauchemin Tuesday, August 30, 2016 6:21 PM Moved to SSIS forum for best response on script component
    Monday, August 29, 2016 6:58 PM