需要使用包含COZYROC表差异组件的BIML生成和SSIS包的代码

Question

是否有人可以帮助使用包含COZYROC表差异组件的BIML生成SSIS包的代码示例？

我在BimlScript.com上找到了一段示例代码，它看起来像您期望看到的到COZYROC表差异组件的代码，但实际上并不包含表差异部分。https://www.bimlscript.com/Snippet/Details/63

下面是我为表diff组件使用的代码：

<CustomComponent Name="TableDiff" ComponentTypeName="CozyRoc.SqlServer.SSIS.TableDifference, CozyRoc.SSISPlus.2019, Version=1.0.0.0, Culture=neutral, PublicKeyToken=16cf490bb80c34ea" Version="3">
  <CustomProperties>
      <CustomProperty Name="NewInputLineageIDs" DataType="Int32" IsArray="true" TypeConverter="" UITypeEditor="" ContainsId="true"></CustomProperty> 
      <CustomProperty Name="OldInputLineageIDs" DataType="Int32" IsArray="true" TypeConverter="" UITypeEditor="" ContainsId="true"></CustomProperty> 
      <CustomProperty Name="KeyOrders" DataType="Int32" IsArray="true" TypeConverter="" UITypeEditor=""></CustomProperty>
      <CustomProperty Name="UpdateIDs" DataType="Int32" IsArray="true" TypeConverter="" UITypeEditor=""></CustomProperty>
      <CustomProperty Name="CheckOptions" DataType="Int32" IsArray="true" TypeConverter="" UITypeEditor=""></CustomProperty>
      <CustomProperty Name="Names" DataType="String" IsArray="true" TypeConverter="" UITypeEditor=""></CustomProperty>

      <CustomProperty Name="StringCompareCultureId" DataType="Int32" TypeConverter="" UITypeEditor="">0</CustomProperty>
      <CustomProperty Name="StringCompareIgnoreCase" DataType="Boolean" TypeConverter="" UITypeEditor="">false</CustomProperty>
      <CustomProperty Name="StringCompareIgnoreKana" DataType="Boolean" TypeConverter="" UITypeEditor="">false</CustomProperty>
      <CustomProperty Name="StringCompareIgnoreWidth" DataType="Boolean" TypeConverter="" UITypeEditor="">false</CustomProperty>
      <CustomProperty Name="StringCompareIgnoreNonSpace" DataType="Boolean" TypeConverter="" UITypeEditor="">false</CustomProperty>
      <CustomProperty Name="StringCompareIgnoreSymbols" DataType="Boolean" TypeConverter="" UITypeEditor="">false</CustomProperty>
      <CustomProperty Name="StringCompareSort" DataType="Boolean" TypeConverter="" UITypeEditor="">false</CustomProperty>
      <CustomProperty Name="EnableLogOutput" DataType="Boolean" TypeConverter="NOTBROWSABLE" UITypeEditor="">false</CustomProperty>
      <CustomProperty Name="IncludeInputColumnsInLogOutput" DataType="Boolean" TypeConverter="" UITypeEditor="">true</CustomProperty>
  </CustomProperties>

  <Annotations>
      <Annotation AnnotationType="Description">Find the difference between two data flows."</Annotation>
  </Annotations>

  <InputPaths>
      <InputPath OutputPathName="MuilticastLeft.Output1" SsisName="New Data Flow" Identifier="NEW"></InputPath>
      <InputPath OutputPathName="MuilticastRight.Output1" SsisName="Old Data Flow" Identifier="OLD"></InputPath>
  </InputPaths>

Answer 1

BimlExpress允许您将现有的SSIS包反向工程到Biml。由于我的机器上没有安装cozyroc组件，所以我可以根据链接组件进行猜测，但通常情况下，这将是一个CustomComponent，填充了特定于CozyRoc的位。

首先是程序集的名称(猜测)以及公钥令牌。您可以右键单击关联的dll，选择“属性”并从“详细信息”选项卡获取此信息。

<CustomComponent Name="Table Difference" ComponentTypeName="CozyRoc.SqlServer.SSIS.TableDifference, CozyRoc.SSISPlus.XXXX, Version=1.0.0.0, Culture=neutral, PublicKeyToken=XXXXXXXXXX" ContactInfo="">
    <CustomProperties>
        <CustomProperty Name="IgnoreCase" DataType="Boolean" TypeConverter="" UITypeEditor="">false</CustomProperty>
        <!-- etc -->
    </CustomProperties>
    <InputPaths>
        <InputPath OutputPathName="OLE DB Source.Output" SsisName="Input" ErrorOrTruncationOperation="" Identifier="Input" />
    </InputPaths>
    <OutputPaths>
        <OutputPath Name="Output" ErrorOrTruncationOperation="" SynchronousInput="Input" />
    </OutputPaths>
</CustomComponent>

通常，我希望您将为组件中的所有设置添加一个CustomProperty。如您所见，与具有多个参数vs3的流同步http://www.cozyroc.com/ssis/table-difference相比，表的差异要复杂得多。