Azure数据工厂复制XML活动

wpcxdonn 于 2023-01-14 发布在其他

关注(0)|答案(1)|浏览(161)

我正在使用“复制活动”将XML复制到数据库。
XML文件具有嵌套结构，因此我在“Cond_Tbl_Data_Record”级别定义了一个“集合引用”。mapping以下内容正确写入数据库。

`<Cond_Tbl_Data_Set>
    <Cond_Tbl_Data_Record>
        <Base_Per_Quantity>1</Base_Per_Quantity>
        <Base_UOM_Code>GA</Base_UOM_Code>
        <Condition_Table_ID>A02</Condition_Table_ID>
        <Condition_Type>COCO</Condition_Type>
        <Condition_Value>829</Condition_Value>
        <Currency_Code>USC</Currency_Code>
        <Extraction_Time>20230113 19:41:03</Extraction_Time>
        <Key_Values>US/000001/001</Key_Values>
        <Valid_From_Date>20230113</Valid_From_Date>
        <Valid_To_Date>99991231</Valid_To_Date>
        <Effective_Start_Time>13:22:42</Effective_Start_Time>
        <Condition_Change_Value>300</Condition_Change_Value>
    </Cond_Tbl_Data_Record>
    <Cond_Tbl_Data_Record>
        <Base_Per_Quantity>1</Base_Per_Quantity>
        <Base_UOM_Code>GA</Base_UOM_Code>
        <Condition_Table_ID>A04</Condition_Table_ID>
        <Condition_Type>COCO</Condition_Type>
        <Condition_Value>829</Condition_Value>
        <Currency_Code>USC</Currency_Code>
        <Extraction_Time>20230113 19:41:03</Extraction_Time>
        <Key_Values>US/000001/002</Key_Values>
        <Valid_From_Date>20230113</Valid_From_Date>
        <Valid_To_Date>99991231</Valid_To_Date>
        <Effective_Start_Time>13:22:42</Effective_Start_Time>
        <Condition_Change_Value>300</Condition_Change_Value>
    </Cond_Tbl_Data_Record>
</Cond_Tbl_Data_Set>`

但是以下内容根本不写入DB。

`<Cond_Tbl_Data_Set>
    <Cond_Tbl_Data_Record>
        <Base_Per_Quantity>1</Base_Per_Quantity>
        <Base_UOM_Code>GA</Base_UOM_Code>
        <Condition_Table_ID>A02</Condition_Table_ID>
        <Condition_Type>COCO</Condition_Type>
        <Condition_Value>829</Condition_Value>
        <Currency_Code>USC</Currency_Code>
        <Extraction_Time>20230113 19:41:03</Extraction_Time>
        <Key_Values>US/000001/001</Key_Values>
        <Valid_From_Date>20230113</Valid_From_Date>
        <Valid_To_Date>99991231</Valid_To_Date>
        <Effective_Start_Time>13:22:42</Effective_Start_Time>
        <Condition_Change_Value>300</Condition_Change_Value>
    </Cond_Tbl_Data_Record>
</Cond_Tbl_Data_Set>`

我尝试重新导入架构，但仍然无效

Azure

来源：https://stackoverflow.com/questions/75104282/azure-data-factory-copy-xml-activity