问题描述
关于我的主题:https://social.msdn.microsoft.com/Forums/sqlserver/en-US/2bdcbe98-8d0f-425d-9dd8-dbd20e005643/how-to-parse-a- json-column-into-multiple-columns-in-ssis?forum = sqlintegrationservices
附加样本数据集。
我已经将列解析为多个列,如ID,记录类型,创建时间现在,我想将数据集数组的名称/值对解析为多行。
我的代码应该转换:
{" ID":" f41dab","记录类型":20," CREATIONTIME":" 2017-07-23T10:18:40","操作":" ViewDashboard","工作量":" PowerBI","WorkSpaceName":"My Workspace","WorkspaceId":"My
Workspace","Datasets":[{" DatasetId":" 798038e9"," DatasetName" :" 2015年,时薪负荷和曲OT;},{" datasetID所":" 247"," DatasetName来":" export_waitstat1"},{" datasetID所":" F9E"," DatasetName来":" hydro_May18"}]
TO
ATTACHED IMAGE。
|
In relation to my thread:https://social.msdn.microsoft.com/Forums/sqlserver/en-US/2bdcbe98-8d0f-425d-9dd8-dbd20e005643/how-to-parse-a-json-column-into-multiple-columns-in-ssis?forum=sqlintegrationservices
Sample data set attached.
I am already parsing the column into multiple columns like ID,Record Type,Creation Time etc.Now,I want to also parser Datasets array of name/value pairs into multiple rows.
My code should convert :
{"Id":"f41dab","RecordType":20,"CreationTime":"2017-07-23T10:18:40","Operation":"ViewDashboard","Workload":"PowerBI","WorkSpaceName":"My Workspace","WorkspaceId":"My Workspace","Datasets":[{"DatasetId":"798038e9","DatasetName":"2015-hourly-loads"},{"DatasetId":"247","DatasetName":"export_waitstat1"},{"DatasetId":"f9e","DatasetName":"hydro_May18"}]
TO
ATTACHED IMAGE.
这篇关于将包含数组的JSON列拆分为多行的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!