I’m trying to import data from a JSON file (downloaded from an API) to an SQL server trough ZappySys’s Connector for SSIS.
Everything works, but I still have a problem… In my JSON the data looks like this

{
        "CompanyName":  "Contoso Corp",
        "CompanyAccountId":  000000,
        "CompanyVatId":  "EMPTY",
        "BillingInterval":  "04/2022",
        "Charges":  [
                        "@{ServiceName=Microsoft 365 Business Basic; ServiceId=101653_Office365BusinessEssentials_99204; AccountId=882931; PriceableItemDescription=Microsoft 365 Business Basic with Billing Type Monthly per unit of NumberofSeats; MaterialNumber=2392014; BillableParameter=Billing Type=Monthly Number of CSP licenses=23; ContractId=00123456789; BillingStartDate=2021-04-26T11:54:06.87; ActualChargeInterval=01.04.2022 - 01.05.2022; Costs=111.5100; CostsOfUnit=4.8481; SalesPrice=112.7000; SalesPriceOfUnit=4.9000; Currency=CHF; VendorReference=ABCDEF-GHIJKL-MNOPQR-STUVWX; UDRCValue=23.0; PriceableItemId=3692; ProductNumber=AAA-10624; VendorName=Microsoft}",
                        "@{ServiceName=Letsignit (Cloud Monthly); ServiceId=447035_LetsignitCloud_18119; AccountId=887285; PriceableItemDescription=Letsignit (Cloud Monthly) with Plan Business per unit of Licencesnumber; MaterialNumber=3190889; BillableParameter=Plan=Business Licences number=18; ContractId=00123456789; BillingStartDate=2021-05-11T13:18:20.83; ActualChargeInterval=01.04.2022 - 01.05.2022; Costs=18.0000; CostsOfUnit=1.0000; SalesPrice=23.7600; SalesPriceOfUnit=1.3200; Currency=CHF; UDRCValue=18.0; PriceableItemId=39590; VendorName=Letsignit}"
                    ],
        "InvoiceNumber":  "12345678",
        "Salesman":  "[email protected]"
    }, 

The ZappySys connector successfuly import CompanyName, CompanyAccountId, CompanyVatId, BillingInterval, InvoiceNumber and Salesman, but import everything in Charges as a single SQL column, but I wanted to have a column “ServiceName”, a “ServiceId” etc.

Is it possible to do this because it’s like “a JSON file in a JSON file” and I didn’t find how to do that?

Thanks a lot for your help

Link to the ZappySys connector page : https://zappysys.com/products/ssis-powerpack/ssis-json-file-source/