Json to sql table

[Anonymous]

Hi ,
 I had a requirement where i need to take data from json file and load it in table (sql server).
can anyone please help me in this .
my sample json file is 
[
    {
        "CostRate":  "0.0000",
        "ModifiedDate":  "06/01/1998 00:00:00",
        "Name":  "Tool Crib",
        "Availability":  "0.00",
        "LocationID":  "1"
    },
    {
        "CostRate":  "0.0000",
        "ModifiedDate":  "06/01/1998 00:00:00",
        "Name":  "Sheet Metal Racks",
        "Availability":  "0.00",
        "LocationID":  "2"
    },
    {
        "CostRate":  "0.0000",
        "ModifiedDate":  "06/01/1998 00:00:00",
        "Name":  "Paint Shop",
        "Availability":  "0.00",
        "LocationID":  "3"
    },
    {
        "CostRate":  "0.0000",
        "ModifiedDate":  "06/01/1998 00:00:00",
        "Name":  "Paint Storage",
        "Availability":  "0.00",
        "LocationID":  "4"
    },
    {
        "CostRate":  "0.0000",
        "ModifiedDate":  "06/01/1998 00:00:00",
        "Name":  "Metal Storage",
        "Availability":  "0.00",
        "LocationID":  "5"
    },
    {
        "CostRate":  "0.0000",
        "ModifiedDate":  "06/01/1998 00:00:00",
        "Name":  "Miscellaneous Storage",
        "Availability":  "0.00",
        "LocationID":  "6"
    },
    {
        "CostRate":  "0.0000",
        "ModifiedDate":  "06/01/1998 00:00:00",
        "Name":  "Finished Goods Storage",
        "Availability":  "0.00",
        "LocationID":  "7"
    },
    {
        "CostRate":  "22.5000",
        "ModifiedDate":  "06/01/1998 00:00:00",
        "Name":  "Frame Forming",
        "Availability":  "96.00",
        "LocationID":  "10"
    },
    {
        "CostRate":  "25.0000",
        "ModifiedDate":  "06/01/1998 00:00:00",
        "Name":  "Frame Welding",
        "Availability":  "108.00",
        "LocationID":  "20"
    },
    {
        "CostRate":  "14.5000",
        "ModifiedDate":  "06/01/1998 00:00:00",
        "Name":  "Debur and Polish",
        "Availability":  "120.00",
        "LocationID":  "30"
    },
    {
        "CostRate":  "15.7500",
        "ModifiedDate":  "06/01/1998 00:00:00",
        "Name":  "Paint",
        "Availability":  "120.00",
        "LocationID":  "40"
    },
    {
        "CostRate":  "18.0000",
        "ModifiedDate":  "06/01/1998 00:00:00",
        "Name":  "Specialized Paint",
        "Availability":  "80.00",
        "LocationID":  "45"
    },
    {
        "CostRate":  "12.2500",
        "ModifiedDate":  "06/01/1998 00:00:00",
        "Name":  "Subassembly",
        "Availability":  "120.00",
        "LocationID":  "50"
    },
    {
        "CostRate":  "12.2500",
        "ModifiedDate":  "06/01/1998 00:00:00",
        "Name":  "Final Assembly",
        "Availability":  "120.00",
        "LocationID":  "60"
    }
]

Regards,
Miranda

[Anonymous]

Did you look at the tJSONExtractFields component?
Your job will look like , tFileInputJSON --> tJSONExtractFields --> tMSSQLOutput