问SSIS自定义组件salesforce源(kingswaysoft)没有通过BIML正确配置
EN

Stack Overflow用户

提问于 2018-07-04 07:16:49

回答 1查看 648关注 0票数 2

我试图使用金斯瓦伊软 SSIS连接器连接Salesforce。

我能够在数据集成项目中使用成功地连接到salesforce，并从Salesforce检索数据。因为我必须生成100+ SSIS包来处理，所以我尝试使用BIML编写它，后者反过来生成SSIS包。

我的BIML代码如下所示

<Biml xmlns="http://schemas.varigence.com/biml.xsd">
    <Connections>
      <CustomSsisConnection Name="Salesforce Connection Manager" CreationName="Salesforce (KingswaySoft)" ObjectData="&lt;SalesforceConnectionManager ConnectionString=&quot;InstanceType=Production;UserName=XXXXXXXXXXX;ServiceTimeout=250;ProxyMode=NoProxy;ProxyServer=;ProxyServerPort=0;ProxyUsername=;RetryOnIntermittentErrors=True&quot;&gt;&#xD;&#xA;  &lt;Password Sensitive=&quot;1&quot; xmlns=&quot;www.microsoft.com/SqlServer/Dts&quot; Encrypted=&quot;0&quot;&gt;XXXXXXXXX&lt;/Password&gt;&#xD;&#xA;  &lt;SecurityToken Sensitive=&quot;1&quot; xmlns=&quot;www.microsoft.com/SqlServer/Dts&quot; Encrypted=&quot;0&quot;&gt;XXXXXXXXXXXXXXXXXX&lt;/SecurityToken&gt;&#xD;&#xA;&lt;/SalesforceConnectionManager&gt;" />
    </Connections>
  <Packages>
    <Package Name="Package_1" Language="None" ProtectionLevel="EncryptSensitiveWithUserKey" SsisPackageType="5" VersionBuild="9" CreatorName="84336" CreatorComputerName="84336-WX-1" CreationDate="2018-07-03T15:40:13">
      <Variables>
        <Variable Name="recordsCount" DataType="Int32" IncludeInDebugDump="Include">0</Variable>
      </Variables>
      <Tasks>
        <Dataflow Name="Data Flow Task">
          <Transformations>
            <RowCount Name="Row Count" VariableName="User.recordsCount">
              <InputPath OutputPathName="Salesforce Source.Salesforce Source Output" />
            </RowCount>
            <CustomComponent Name="Salesforce Source" ComponentTypeName="KingswaySoft.IntegrationToolkit.Salesforce.SalesforceSourceComponent" ContactInfo="KingswaySoft Inc.; http://www.kingswaysoft.com; support@kingswaysoft.com; Copyright (c) 2011-2018 KingswaySoft Inc.">
              <DataflowOverrides>
                <OutputPath OutputPathName="Salesforce Source Output">
                <Columns>
                    <Column ErrorRowDisposition="FailComponent" TruncationRowDisposition="FailComponent" ColumnName="AccountNumber" />
                </Columns>
                </OutputPath>
              </DataflowOverrides>
              <CustomProperties>
                <CustomProperty Name="SourceType" DataType="Int32" TypeConverter="KingswaySoft.IntegrationToolkit.Salesforce.SalesforceSourceType" SupportsExpression="true" Description="Specifies the type of source data from Salesforce">0</CustomProperty>
                <CustomProperty Name="SourceObject" DataType="String" SupportsExpression="true" Description="Salesforce object to retrieve data from.">Account</CustomProperty>
                <CustomProperty Name="ObjectQuery" DataType="String" SupportsExpression="true" Description="Salesforce object query statement."></CustomProperty>
                <CustomProperty Name="BatchSize" DataType="Int32" SupportsExpression="true" Description="Specifies the batch size of the query.">1000</CustomProperty>
                <CustomProperty Name="IncludeDeletedArchived" DataType="Boolean" SupportsExpression="true" Description="Specifies whether deleted or archived records should be returned.">false</CustomProperty>
                <CustomProperty Name="UseBulkApi" DataType="Boolean" SupportsExpression="true" Description="Specify whether to use Salesforce Bulk API to read data.">false</CustomProperty>
                <CustomProperty Name="OutputTimezone" DataType="Int32" TypeConverter="KingswaySoft.IntegrationToolkit.Common.DescriptiveEnumTypeConverter`1[[KingswaySoft.IntegrationToolkit.Salesforce.SfdcSourceOutputTimezone, KingswaySoft.IntegrationToolkit.Salesforce, Version=1.0.2017.0, Culture=neutral, PublicKeyToken=705df8e0751bcea7]], KingswaySoft.IntegrationToolkit.Salesforce, Version=1.0.2017.0, Culture=neutral, PublicKeyToken=705df8e0751bcea7" SupportsExpression="true" Description="Specifies the output timezone for Salesforce datetime fields.">1</CustomProperty>
                <CustomProperty Name="PKChunkingHeader" DataType="String" SupportsExpression="true" Description="Specify the PK Chunking Header that helps with Bulk API data read performance."></CustomProperty>
              </CustomProperties>
              <OutputPaths>
                <OutputPath Name="Salesforce Source Output">
                  <OutputColumns>
                    <OutputColumn Name="AccountNumber" Length="40" DataType="String" ExternalMetadataColumnName="AccountNumber" ErrorOrTruncationOperation="Conversion" ErrorRowDisposition="FailComponent" TruncationRowDisposition="FailComponent" />
                  </OutputColumns>
                  <ExternalColumns>
                    <ExternalColumn Name="AccountNumber" Length="40" DataType="String" />
                  </ExternalColumns>
                </OutputPath>
              </OutputPaths>
              <Connections>
                <Connection Name="Salesforce" ConnectionName="Salesforce Connection Manager" />
              </Connections>
            </CustomComponent>
          </Transformations>
        </Dataflow>
      </Tasks>
      <Connections>
        <Connection ConnectionName="Salesforce Connection Manager" />
      </Connections>
    </Package>
  </Packages>
</Biml>

我能够看到在从BIML生成SSIS包之后，在BI项目中创建了Salesforce连接(正确)。