XYY.BI.ELT/派送渠道称重上网分位数.dtsx

<?xml version="1.0"?>
<DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts"
  DTS:refId="Package"
  DTS:CreationDate="8/5/2022 7:04:04 PM"
  DTS:CreationName="Microsoft.Package"
  DTS:CreatorComputerName="FAN"
  DTS:CreatorName="FAN\dell"
  DTS:DTSID="{D46627C1-347F-461F-9579-0C32561FE0CF}"
  DTS:ExecutableType="Microsoft.Package"
  DTS:LastModifiedProductVersion="16.0.694.0"
  DTS:LocaleID="2052"
  DTS:ObjectName="派送渠道称重上网分位数"
  DTS:PackageType="5"
  DTS:VersionBuild="26"
  DTS:VersionGUID="{941F4C76-FC10-437E-9AE1-7E97850D3DB7}">
  <DTS:Property
    DTS:Name="PackageFormatVersion">8</DTS:Property>
  <DTS:ConnectionManagers>
    <DTS:ConnectionManager
      DTS:refId="Package.ConnectionManagers[rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy1]"
      DTS:CreationName="OLEDB"
      DTS:DTSID="{B4456A38-47A2-4662-B2DF-82A2E4E11628}"
      DTS:ObjectName="rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy1">
      <DTS:ObjectData>
        <DTS:ConnectionManager
          DTS:ConnectRetryCount="1"
          DTS:ConnectRetryInterval="5"
          DTS:ConnectionString="Data Source=rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433;User ID=xyy;Initial Catalog=xyy_wms;Provider=SQLNCLI11.1;Persist Security Info=True;Auto Translate=False;Application Name=SSIS-Package1-{B4456A38-47A2-4662-B2DF-82A2E4E11628}rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy1;">
          <DTS:Password
            DTS:Name="Password"
            Sensitive="1"
            Encrypted="1">AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAYaXc47IOuU6ltmljCrTt9wAAAAAIAAAARABUAFMAAAAQZgAAAAEAACAAAABYPcU39KZa+ot5ngGHTykipBlnYBCZ6n0ZvML9qSSsQAAAAAAOgAAAAAIAACAAAACfjM8Y/BAJqo0685r5XVeQHb4n6EWKZVSPK2bZRHeq1zAAAABufcQGxVtXMQnoTfxK0Dgp0GhXpiDN2IKvBq8sReJ9twsVTbvlBZQsmTRv54fBbd9AAAAA905pHbUehIAKIYttbcDHyZR5h653ETFi8VZX/jN5+mP9JStMnSCrOf6FnrEvp6shOdoj0vzBWf+bXZLaEXmZQQ</DTS:Password>
        </DTS:ConnectionManager>
      </DTS:ObjectData>
    </DTS:ConnectionManager>
  </DTS:ConnectionManagers>
  <DTS:Variables />
  <DTS:Executables>
    <DTS:Executable
      DTS:refId="Package\上网-签收分位数"
      DTS:CreationName="Microsoft.Pipeline"
      DTS:Description="数据流任务"
      DTS:DTSID="{3378BC28-E229-422B-A8BB-13E996319756}"
      DTS:ExecutableType="Microsoft.Pipeline"
      DTS:LocaleID="-1"
      DTS:ObjectName="上网-签收分位数"
      DTS:TaskContact="Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1">
      <DTS:Variables />
      <DTS:ObjectData>
        <pipeline
          version="1">
          <components>
            <component
              refId="Package\上网-签收分位数\95%上网签收分位数(提单)"
              componentClassID="Microsoft.OLEDBSource"
              contactInfo="OLE DB 源;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; 保留所有权利; http://www.microsoft.com/sql/support;7"
              description="OLE DB 源"
              name="95%上网签收分位数(提单)"
              usesDispositions="true"
              version="7">
              <properties>
                <property
                  dataType="System.Int32"
                  description="命令超时前等待的时间(秒)。值为 0，表示无限期等待。"
                  name="CommandTimeout">0</property>
                <property
                  dataType="System.String"
                  description="指定用于打开行集的数据库对象的名称。"
                  name="OpenRowset"></property>
                <property
                  dataType="System.String"
                  description="指定包含用于打开行集的数据库对象名的变量。"
                  name="OpenRowsetVariable"></property>
                <property
                  dataType="System.String"
                  description="要执行的 SQL 命令。"
                  name="SqlCommand"
                  UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor, Microsoft.DataTransformationServices.Controls, Version=16.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91">with t1 as(
select 
	 PERCENT_RANK() 
		over (  partition by a.LadingBillNumber,f.PublicName  
		order by  datediff(HOUR,d.onlinetime,d.signtime)/24.0) pr
	 ,datediff(HOUR,d.onlinetime,d.signtime)/24.0 as r,
	 a.LadingBillNumber,d.TrackingNumber,f.PublicName 
	from
  Logistics_LadingBill(nolock)a join Logistics_Box(nolock)b on a.LadingBillNumber=b.LadingBillNumber and a.IsDeleted=0 and b.IsDelete=0
	join Logistics_BoxDetail(nolock)c on c.BoxId=b.Id
	join Logistics_Trace(nolock)d on d.OrderId=c.OrderId 
	join Order_Order(nolock)e on e.id=d.OrderId
	join Logistics_Channel(nolock) f on f.id=e.ChannelId
	join Logistics_Channel(nolock)g on g.id=e.CreateOrderChannelId
	join Logistics_Public(nolock)h on h.Code=g.PublicCode
	where a.CreateTime&gt;'2022-05-01'
 )
 select  LadingBillNumber,PublicName,MIN(r)time from t1 where      pr&gt;=0.95
   group by LadingBillNumber,PublicName</property>
                <property
                  dataType="System.String"
                  description="包含要执行的 SQL 命令的变量。"
                  name="SqlCommandVariable"></property>
                <property
                  dataType="System.Int32"
                  description="指定当数据源中没有代码页信息时使用的列代码页。"
                  name="DefaultCodePage">936</property>
                <property
                  dataType="System.Boolean"
                  description="描述字符数据时，强制使用 DefaultCodePage 属性值。"
                  name="AlwaysUseDefaultCodePage">false</property>
                <property
                  dataType="System.Int32"
                  description="指定用于访问数据库的模式。"
                  name="AccessMode"
                  typeConverter="AccessMode">2</property>
                <property
                  dataType="System.String"
                  description="SQL 命令中的参数与变量之间的映射。"
                  name="ParameterMapping"></property>
              </properties>
              <connections>
                <connection
                  refId="Package\上网-签收分位数\95%上网签收分位数(提单).Connections[OleDbConnection]"
                  connectionManagerID="Package.ConnectionManagers[rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy1]"
                  connectionManagerRefId="Package.ConnectionManagers[rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy1]"
                  description="指定用于访问数据库的 OLE DB 运行时连接。"
                  name="OleDbConnection" />
              </connections>
              <outputs>
                <output
                  refId="Package\上网-签收分位数\95%上网签收分位数(提单).Outputs[OLE DB 源输出]"
                  name="OLE DB 源输出">
                  <outputColumns>
                    <outputColumn
                      refId="Package\上网-签收分位数\95%上网签收分位数(提单).Outputs[OLE DB 源输出].Columns[提单号]"
                      dataType="wstr"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\上网-签收分位数\95%上网签收分位数(提单).Outputs[OLE DB 源输出].ExternalColumns[LadingBillNumber]"
                      length="50"
                      lineageId="Package\上网-签收分位数\95%上网签收分位数(提单).Outputs[OLE DB 源输出].Columns[提单号]"
                      name="提单号"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\上网-签收分位数\95%上网签收分位数(提单).Outputs[OLE DB 源输出].Columns[分位时间]"
                      dataType="numeric"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\上网-签收分位数\95%上网签收分位数(提单).Outputs[OLE DB 源输出].ExternalColumns[time]"
                      lineageId="Package\上网-签收分位数\95%上网签收分位数(提单).Outputs[OLE DB 源输出].Columns[分位时间]"
                      name="分位时间"
                      precision="17"
                      scale="6"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\上网-签收分位数\95%上网签收分位数(提单).Outputs[OLE DB 源输出].Columns[派送渠道名称]"
                      dataType="wstr"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\上网-签收分位数\95%上网签收分位数(提单).Outputs[OLE DB 源输出].ExternalColumns[PublicName]"
                      length="64"
                      lineageId="Package\上网-签收分位数\95%上网签收分位数(提单).Outputs[OLE DB 源输出].Columns[派送渠道名称]"
                      name="派送渠道名称"
                      truncationRowDisposition="FailComponent" />
                  </outputColumns>
                  <externalMetadataColumns
                    isUsed="True">
                    <externalMetadataColumn
                      refId="Package\上网-签收分位数\95%上网签收分位数(提单).Outputs[OLE DB 源输出].ExternalColumns[LadingBillNumber]"
                      dataType="wstr"
                      length="50"
                      name="LadingBillNumber" />
                    <externalMetadataColumn
                      refId="Package\上网-签收分位数\95%上网签收分位数(提单).Outputs[OLE DB 源输出].ExternalColumns[time]"
                      dataType="numeric"
                      name="time"
                      precision="17"
                      scale="6" />
                    <externalMetadataColumn
                      refId="Package\上网-签收分位数\95%上网签收分位数(提单).Outputs[OLE DB 源输出].ExternalColumns[PublicName]"
                      dataType="wstr"
                      length="64"
                      name="PublicName" />
                  </externalMetadataColumns>
                </output>
                <output
                  refId="Package\上网-签收分位数\95%上网签收分位数(提单).Outputs[OLE DB 源错误输出]"
                  isErrorOut="true"
                  name="OLE DB 源错误输出">
                  <outputColumns>
                    <outputColumn
                      refId="Package\上网-签收分位数\95%上网签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[LadingBillNumber]"
                      dataType="wstr"
                      length="50"
                      lineageId="Package\上网-签收分位数\95%上网签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[LadingBillNumber]"
                      name="LadingBillNumber" />
                    <outputColumn
                      refId="Package\上网-签收分位数\95%上网签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[PublicName]"
                      dataType="wstr"
                      length="64"
                      lineageId="Package\上网-签收分位数\95%上网签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[PublicName]"
                      name="PublicName" />
                    <outputColumn
                      refId="Package\上网-签收分位数\95%上网签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[time]"
                      dataType="numeric"
                      lineageId="Package\上网-签收分位数\95%上网签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[time]"
                      name="time"
                      precision="17"
                      scale="6" />
                    <outputColumn
                      refId="Package\上网-签收分位数\95%上网签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[ErrorCode]"
                      dataType="i4"
                      lineageId="Package\上网-签收分位数\95%上网签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[ErrorCode]"
                      name="ErrorCode"
                      specialFlags="1" />
                    <outputColumn
                      refId="Package\上网-签收分位数\95%上网签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[ErrorColumn]"
                      dataType="i4"
                      lineageId="Package\上网-签收分位数\95%上网签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[ErrorColumn]"
                      name="ErrorColumn"
                      specialFlags="2" />
                  </outputColumns>
                  <externalMetadataColumns />
                </output>
              </outputs>
            </component>
            <component
              refId="Package\上网-签收分位数\OLE DB 目标 1"
              componentClassID="Microsoft.OLEDBDestination"
              contactInfo="OLE DB 目标;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; 保留所有权利; http://www.microsoft.com/sql/support;4"
              description="OLE DB 目标"
              name="OLE DB 目标 1"
              usesDispositions="true"
              version="4">
              <properties>
                <property
                  dataType="System.Int32"
                  description="命令超时前等待的时间(秒)。值为 0，表示无限期等待。"
                  name="CommandTimeout">0</property>
                <property
                  dataType="System.String"
                  description="指定用于打开行集的数据库对象的名称。"
                  name="OpenRowset">[BaseETL_95P_Ladding_DeliveryChanne_Online]</property>
                <property
                  dataType="System.String"
                  description="指定包含用于打开行集的数据库对象名的变量。"
                  name="OpenRowsetVariable"></property>
                <property
                  dataType="System.String"
                  description="要执行的 SQL 命令。"
                  name="SqlCommand"
                  UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor, Microsoft.DataTransformationServices.Controls, Version=16.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"></property>
                <property
                  dataType="System.Int32"
                  description="指定当数据源中没有代码页信息时使用的列代码页。"
                  name="DefaultCodePage">936</property>
                <property
                  dataType="System.Boolean"
                  description="描述字符数据时，强制使用 DefaultCodePage 属性值。"
                  name="AlwaysUseDefaultCodePage">false</property>
                <property
                  dataType="System.Int32"
                  description="指定用于访问数据库的模式。"
                  name="AccessMode"
                  typeConverter="AccessMode">3</property>
                <property
                  dataType="System.Boolean"
                  description="指示是否将为标识列提供的值复制到目标。如果设置为 False，则将在目标中为标识列自动生成值。仅当启用了快速加载时适用。"
                  name="FastLoadKeepIdentity">false</property>
                <property
                  dataType="System.Boolean"
                  description="指示对于包含 Null 值的列是否将 Null 值插入目标中。如果为 False，则对于包含 Null 值的列会将其默认值插入目标中。仅当启用了快速加载时适用。"
                  name="FastLoadKeepNulls">false</property>
                <property
                  dataType="System.String"
                  description="指定将用于快速加载的选项。仅当启用了快速加载时适用。"
                  name="FastLoadOptions">TABLOCK,CHECK_CONSTRAINTS</property>
                <property
                  dataType="System.Int32"
                  description="指定在插入数据期间何时发出提交命令。如果值为 0，则指定在数据插入结束时发出一个提交命令。仅当启用了快速加载时适用。"
                  name="FastLoadMaxInsertCommitSize">2147483647</property>
              </properties>
              <connections>
                <connection
                  refId="Package\上网-签收分位数\OLE DB 目标 1.Connections[OleDbConnection]"
                  connectionManagerID="Package.ConnectionManagers[rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy1]"
                  connectionManagerRefId="Package.ConnectionManagers[rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy1]"
                  description="指定用于访问数据库的 OLE DB 运行时连接。"
                  name="OleDbConnection" />
              </connections>
              <inputs>
                <input
                  refId="Package\上网-签收分位数\OLE DB 目标 1.Inputs[OLE DB 目标输入]"
                  errorOrTruncationOperation="插入"
                  errorRowDisposition="FailComponent"
                  hasSideEffects="true"
                  name="OLE DB 目标输入">
                  <inputColumns>
                    <inputColumn
                      refId="Package\上网-签收分位数\OLE DB 目标 1.Inputs[OLE DB 目标输入].Columns[提单号]"
                      cachedDataType="wstr"
                      cachedLength="50"
                      cachedName="提单号"
                      externalMetadataColumnId="Package\上网-签收分位数\OLE DB 目标 1.Inputs[OLE DB 目标输入].ExternalColumns[提单号]"
                      lineageId="Package\上网-签收分位数\95%上网签收分位数(提单).Outputs[OLE DB 源输出].Columns[提单号]" />
                    <inputColumn
                      refId="Package\上网-签收分位数\OLE DB 目标 1.Inputs[OLE DB 目标输入].Columns[分位时间]"
                      cachedDataType="numeric"
                      cachedName="分位时间"
                      cachedPrecision="17"
                      cachedScale="6"
                      externalMetadataColumnId="Package\上网-签收分位数\OLE DB 目标 1.Inputs[OLE DB 目标输入].ExternalColumns[分位时间]"
                      lineageId="Package\上网-签收分位数\95%上网签收分位数(提单).Outputs[OLE DB 源输出].Columns[分位时间]" />
                    <inputColumn
                      refId="Package\上网-签收分位数\OLE DB 目标 1.Inputs[OLE DB 目标输入].Columns[派送渠道名称]"
                      cachedDataType="wstr"
                      cachedLength="64"
                      cachedName="派送渠道名称"
                      externalMetadataColumnId="Package\上网-签收分位数\OLE DB 目标 1.Inputs[OLE DB 目标输入].ExternalColumns[派送渠道名称]"
                      lineageId="Package\上网-签收分位数\95%上网签收分位数(提单).Outputs[OLE DB 源输出].Columns[派送渠道名称]" />
                  </inputColumns>
                  <externalMetadataColumns
                    isUsed="True">
                    <externalMetadataColumn
                      refId="Package\上网-签收分位数\OLE DB 目标 1.Inputs[OLE DB 目标输入].ExternalColumns[提单号]"
                      dataType="wstr"
                      length="50"
                      name="提单号" />
                    <externalMetadataColumn
                      refId="Package\上网-签收分位数\OLE DB 目标 1.Inputs[OLE DB 目标输入].ExternalColumns[分位时间]"
                      dataType="numeric"
                      name="分位时间"
                      precision="17"
                      scale="6" />
                    <externalMetadataColumn
                      refId="Package\上网-签收分位数\OLE DB 目标 1.Inputs[OLE DB 目标输入].ExternalColumns[派送渠道名称]"
                      dataType="wstr"
                      length="64"
                      name="派送渠道名称" />
                  </externalMetadataColumns>
                </input>
              </inputs>
              <outputs>
                <output
                  refId="Package\上网-签收分位数\OLE DB 目标 1.Outputs[OLE DB 目标错误输出]"
                  exclusionGroup="1"
                  isErrorOut="true"
                  name="OLE DB 目标错误输出"
                  synchronousInputId="Package\上网-签收分位数\OLE DB 目标 1.Inputs[OLE DB 目标输入]">
                  <outputColumns>
                    <outputColumn
                      refId="Package\上网-签收分位数\OLE DB 目标 1.Outputs[OLE DB 目标错误输出].Columns[ErrorCode]"
                      dataType="i4"
                      lineageId="Package\上网-签收分位数\OLE DB 目标 1.Outputs[OLE DB 目标错误输出].Columns[ErrorCode]"
                      name="ErrorCode"
                      specialFlags="1" />
                    <outputColumn
                      refId="Package\上网-签收分位数\OLE DB 目标 1.Outputs[OLE DB 目标错误输出].Columns[ErrorColumn]"
                      dataType="i4"
                      lineageId="Package\上网-签收分位数\OLE DB 目标 1.Outputs[OLE DB 目标错误输出].Columns[ErrorColumn]"
                      name="ErrorColumn"
                      specialFlags="2" />
                  </outputColumns>
                  <externalMetadataColumns />
                </output>
              </outputs>
            </component>
          </components>
          <paths>
            <path
              refId="Package\上网-签收分位数.Paths[OLE DB 源输出]"
              endId="Package\上网-签收分位数\OLE DB 目标 1.Inputs[OLE DB 目标输入]"
              name="OLE DB 源输出"
              startId="Package\上网-签收分位数\95%上网签收分位数(提单).Outputs[OLE DB 源输出]" />
          </paths>
        </pipeline>
      </DTS:ObjectData>
    </DTS:Executable>
    <DTS:Executable
      DTS:refId="Package\执行 SQL 任务"
      DTS:CreationName="Microsoft.ExecuteSQLTask"
      DTS:Description="执行 SQL 任务"
      DTS:DTSID="{CDAA4393-ABCD-41C5-AF63-CBD233D72E44}"
      DTS:ExecutableType="Microsoft.ExecuteSQLTask"
      DTS:LocaleID="-1"
      DTS:ObjectName="执行 SQL 任务"
      DTS:ThreadHint="0">
      <DTS:Variables />
      <DTS:ObjectData>
        <SQLTask:SqlTaskData
          SQLTask:Connection="{B4456A38-47A2-4662-B2DF-82A2E4E11628}"
          SQLTask:SqlStatementSource="Truncate table BaseETL_95P_Ladding_DeliveryChanne_Weight&#xA;Truncate table BaseETL_90P_Ladding_DeliveryChanne_Weight&#xA;Truncate table BaseETL_98P_Ladding_DeliveryChanne_Weight&#xA;Truncate table BaseETL_95P_Ladding_DeliveryChanne_Online" xmlns:SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask" />
      </DTS:ObjectData>
    </DTS:Executable>
    <DTS:Executable
      DTS:refId="Package\称重-签收分位数"
      DTS:CreationName="Microsoft.Pipeline"
      DTS:Description="数据流任务"
      DTS:DTSID="{10098FED-4B52-4150-97C1-84E1934FAA72}"
      DTS:ExecutableType="Microsoft.Pipeline"
      DTS:LocaleID="-1"
      DTS:ObjectName="称重-签收分位数"
      DTS:TaskContact="Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1">
      <DTS:Variables />
      <DTS:ObjectData>
        <pipeline
          version="1">
          <components>
            <component
              refId="Package\称重-签收分位数\90%称重签收分位数(提单)"
              componentClassID="Microsoft.OLEDBSource"
              contactInfo="OLE DB 源;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; 保留所有权利; http://www.microsoft.com/sql/support;7"
              description="OLE DB 源"
              name="90%称重签收分位数(提单)"
              usesDispositions="true"
              version="7">
              <properties>
                <property
                  dataType="System.Int32"
                  description="命令超时前等待的时间(秒)。值为 0，表示无限期等待。"
                  name="CommandTimeout">0</property>
                <property
                  dataType="System.String"
                  description="指定用于打开行集的数据库对象的名称。"
                  name="OpenRowset"></property>
                <property
                  dataType="System.String"
                  description="指定包含用于打开行集的数据库对象名的变量。"
                  name="OpenRowsetVariable"></property>
                <property
                  dataType="System.String"
                  description="要执行的 SQL 命令。"
                  name="SqlCommand"
                  UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor, Microsoft.DataTransformationServices.Controls, Version=16.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91">with t1 as(
select 
	 PERCENT_RANK() 
		over (  partition by a.LadingBillNumber,f.PublicName  
		order by  datediff(HOUR,e.ReceiveTime,d.signtime)/24.0) pr
	 ,datediff(HOUR,e.ReceiveTime,d.signtime)/24.0 as r,
	 a.LadingBillNumber,d.TrackingNumber,f.PublicName 
	from
  Logistics_LadingBill(nolock)a join Logistics_Box(nolock)b on a.LadingBillNumber=b.LadingBillNumber and a.IsDeleted=0 and b.IsDelete=0
	join Logistics_BoxDetail(nolock)c on c.BoxId=b.Id
	join Logistics_Trace(nolock)d on d.OrderId=c.OrderId 
	join Order_Order(nolock)e on e.id=d.OrderId
	join Logistics_Channel(nolock) f on f.id=e.ChannelId
	join Logistics_Channel(nolock)g on g.id=e.CreateOrderChannelId
	join Logistics_Public(nolock)h on h.Code=g.PublicCode
	where a.CreateTime&gt;'2022-05-01'
 )
 select  LadingBillNumber,PublicName Name,MIN(r)time from t1 where      pr&gt;=0.90
   group by LadingBillNumber,PublicName</property>
                <property
                  dataType="System.String"
                  description="包含要执行的 SQL 命令的变量。"
                  name="SqlCommandVariable"></property>
                <property
                  dataType="System.Int32"
                  description="指定当数据源中没有代码页信息时使用的列代码页。"
                  name="DefaultCodePage">936</property>
                <property
                  dataType="System.Boolean"
                  description="描述字符数据时，强制使用 DefaultCodePage 属性值。"
                  name="AlwaysUseDefaultCodePage">false</property>
                <property
                  dataType="System.Int32"
                  description="指定用于访问数据库的模式。"
                  name="AccessMode"
                  typeConverter="AccessMode">2</property>
                <property
                  dataType="System.String"
                  description="SQL 命令中的参数与变量之间的映射。"
                  name="ParameterMapping"></property>
              </properties>
              <connections>
                <connection
                  refId="Package\称重-签收分位数\90%称重签收分位数(提单).Connections[OleDbConnection]"
                  connectionManagerID="Package.ConnectionManagers[rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy1]"
                  connectionManagerRefId="Package.ConnectionManagers[rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy1]"
                  description="指定用于访问数据库的 OLE DB 运行时连接。"
                  name="OleDbConnection" />
              </connections>
              <outputs>
                <output
                  refId="Package\称重-签收分位数\90%称重签收分位数(提单).Outputs[OLE DB 源输出]"
                  name="OLE DB 源输出">
                  <outputColumns>
                    <outputColumn
                      refId="Package\称重-签收分位数\90%称重签收分位数(提单).Outputs[OLE DB 源输出].Columns[提单号]"
                      dataType="wstr"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\称重-签收分位数\90%称重签收分位数(提单).Outputs[OLE DB 源输出].ExternalColumns[LadingBillNumber]"
                      length="50"
                      lineageId="Package\称重-签收分位数\90%称重签收分位数(提单).Outputs[OLE DB 源输出].Columns[提单号]"
                      name="提单号"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\称重-签收分位数\90%称重签收分位数(提单).Outputs[OLE DB 源输出].Columns[分位时间]"
                      dataType="numeric"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\称重-签收分位数\90%称重签收分位数(提单).Outputs[OLE DB 源输出].ExternalColumns[time]"
                      lineageId="Package\称重-签收分位数\90%称重签收分位数(提单).Outputs[OLE DB 源输出].Columns[分位时间]"
                      name="分位时间"
                      precision="17"
                      scale="6"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\称重-签收分位数\90%称重签收分位数(提单).Outputs[OLE DB 源输出].Columns[派送渠道名称]"
                      dataType="wstr"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\称重-签收分位数\90%称重签收分位数(提单).Outputs[OLE DB 源输出].ExternalColumns[Name]"
                      length="64"
                      lineageId="Package\称重-签收分位数\90%称重签收分位数(提单).Outputs[OLE DB 源输出].Columns[派送渠道名称]"
                      name="派送渠道名称"
                      truncationRowDisposition="FailComponent" />
                  </outputColumns>
                  <externalMetadataColumns
                    isUsed="True">
                    <externalMetadataColumn
                      refId="Package\称重-签收分位数\90%称重签收分位数(提单).Outputs[OLE DB 源输出].ExternalColumns[LadingBillNumber]"
                      dataType="wstr"
                      length="50"
                      name="LadingBillNumber" />
                    <externalMetadataColumn
                      refId="Package\称重-签收分位数\90%称重签收分位数(提单).Outputs[OLE DB 源输出].ExternalColumns[time]"
                      dataType="numeric"
                      name="time"
                      precision="17"
                      scale="6" />
                    <externalMetadataColumn
                      refId="Package\称重-签收分位数\90%称重签收分位数(提单).Outputs[OLE DB 源输出].ExternalColumns[Name]"
                      dataType="wstr"
                      length="64"
                      name="Name" />
                  </externalMetadataColumns>
                </output>
                <output
                  refId="Package\称重-签收分位数\90%称重签收分位数(提单).Outputs[OLE DB 源错误输出]"
                  isErrorOut="true"
                  name="OLE DB 源错误输出">
                  <outputColumns>
                    <outputColumn
                      refId="Package\称重-签收分位数\90%称重签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[LadingBillNumber]"
                      dataType="wstr"
                      length="50"
                      lineageId="Package\称重-签收分位数\90%称重签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[LadingBillNumber]"
                      name="LadingBillNumber" />
                    <outputColumn
                      refId="Package\称重-签收分位数\90%称重签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[Name]"
                      dataType="wstr"
                      length="64"
                      lineageId="Package\称重-签收分位数\90%称重签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[Name]"
                      name="Name" />
                    <outputColumn
                      refId="Package\称重-签收分位数\90%称重签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[time]"
                      dataType="numeric"
                      lineageId="Package\称重-签收分位数\90%称重签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[time]"
                      name="time"
                      precision="17"
                      scale="6" />
                    <outputColumn
                      refId="Package\称重-签收分位数\90%称重签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[ErrorCode]"
                      dataType="i4"
                      lineageId="Package\称重-签收分位数\90%称重签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[ErrorCode]"
                      name="ErrorCode"
                      specialFlags="1" />
                    <outputColumn
                      refId="Package\称重-签收分位数\90%称重签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[ErrorColumn]"
                      dataType="i4"
                      lineageId="Package\称重-签收分位数\90%称重签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[ErrorColumn]"
                      name="ErrorColumn"
                      specialFlags="2" />
                  </outputColumns>
                  <externalMetadataColumns />
                </output>
              </outputs>
            </component>
            <component
              refId="Package\称重-签收分位数\90称重签收分位数"
              componentClassID="Microsoft.OLEDBDestination"
              contactInfo="OLE DB 目标;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; 保留所有权利; http://www.microsoft.com/sql/support;4"
              description="OLE DB 目标"
              name="90称重签收分位数"
              usesDispositions="true"
              version="4">
              <properties>
                <property
                  dataType="System.Int32"
                  description="命令超时前等待的时间(秒)。值为 0，表示无限期等待。"
                  name="CommandTimeout">0</property>
                <property
                  dataType="System.String"
                  description="指定用于打开行集的数据库对象的名称。"
                  name="OpenRowset">[dbo].[BaseETL_90P_Ladding_DeliveryChanne_Weight]</property>
                <property
                  dataType="System.String"
                  description="指定包含用于打开行集的数据库对象名的变量。"
                  name="OpenRowsetVariable"></property>
                <property
                  dataType="System.String"
                  description="要执行的 SQL 命令。"
                  name="SqlCommand"
                  UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor, Microsoft.DataTransformationServices.Controls, Version=16.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"></property>
                <property
                  dataType="System.Int32"
                  description="指定当数据源中没有代码页信息时使用的列代码页。"
                  name="DefaultCodePage">936</property>
                <property
                  dataType="System.Boolean"
                  description="描述字符数据时，强制使用 DefaultCodePage 属性值。"
                  name="AlwaysUseDefaultCodePage">false</property>
                <property
                  dataType="System.Int32"
                  description="指定用于访问数据库的模式。"
                  name="AccessMode"
                  typeConverter="AccessMode">3</property>
                <property
                  dataType="System.Boolean"
                  description="指示是否将为标识列提供的值复制到目标。如果设置为 False，则将在目标中为标识列自动生成值。仅当启用了快速加载时适用。"
                  name="FastLoadKeepIdentity">false</property>
                <property
                  dataType="System.Boolean"
                  description="指示对于包含 Null 值的列是否将 Null 值插入目标中。如果为 False，则对于包含 Null 值的列会将其默认值插入目标中。仅当启用了快速加载时适用。"
                  name="FastLoadKeepNulls">false</property>
                <property
                  dataType="System.String"
                  description="指定将用于快速加载的选项。仅当启用了快速加载时适用。"
                  name="FastLoadOptions">TABLOCK,CHECK_CONSTRAINTS</property>
                <property
                  dataType="System.Int32"
                  description="指定在插入数据期间何时发出提交命令。如果值为 0，则指定在数据插入结束时发出一个提交命令。仅当启用了快速加载时适用。"
                  name="FastLoadMaxInsertCommitSize">2147483647</property>
              </properties>
              <connections>
                <connection
                  refId="Package\称重-签收分位数\90称重签收分位数.Connections[OleDbConnection]"
                  connectionManagerID="Package.ConnectionManagers[rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy1]"
                  connectionManagerRefId="Package.ConnectionManagers[rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy1]"
                  description="指定用于访问数据库的 OLE DB 运行时连接。"
                  name="OleDbConnection" />
              </connections>
              <inputs>
                <input
                  refId="Package\称重-签收分位数\90称重签收分位数.Inputs[OLE DB 目标输入]"
                  errorOrTruncationOperation="插入"
                  errorRowDisposition="FailComponent"
                  hasSideEffects="true"
                  name="OLE DB 目标输入">
                  <inputColumns>
                    <inputColumn
                      refId="Package\称重-签收分位数\90称重签收分位数.Inputs[OLE DB 目标输入].Columns[提单号]"
                      cachedDataType="wstr"
                      cachedLength="50"
                      cachedName="提单号"
                      externalMetadataColumnId="Package\称重-签收分位数\90称重签收分位数.Inputs[OLE DB 目标输入].ExternalColumns[提单号]"
                      lineageId="Package\称重-签收分位数\90%称重签收分位数(提单).Outputs[OLE DB 源输出].Columns[提单号]" />
                    <inputColumn
                      refId="Package\称重-签收分位数\90称重签收分位数.Inputs[OLE DB 目标输入].Columns[分位时间]"
                      cachedDataType="numeric"
                      cachedName="分位时间"
                      cachedPrecision="17"
                      cachedScale="6"
                      externalMetadataColumnId="Package\称重-签收分位数\90称重签收分位数.Inputs[OLE DB 目标输入].ExternalColumns[分位时间]"
                      lineageId="Package\称重-签收分位数\90%称重签收分位数(提单).Outputs[OLE DB 源输出].Columns[分位时间]" />
                    <inputColumn
                      refId="Package\称重-签收分位数\90称重签收分位数.Inputs[OLE DB 目标输入].Columns[派送渠道名称]"
                      cachedDataType="wstr"
                      cachedLength="64"
                      cachedName="派送渠道名称"
                      externalMetadataColumnId="Package\称重-签收分位数\90称重签收分位数.Inputs[OLE DB 目标输入].ExternalColumns[派送渠道名称]"
                      lineageId="Package\称重-签收分位数\90%称重签收分位数(提单).Outputs[OLE DB 源输出].Columns[派送渠道名称]" />
                  </inputColumns>
                  <externalMetadataColumns
                    isUsed="True">
                    <externalMetadataColumn
                      refId="Package\称重-签收分位数\90称重签收分位数.Inputs[OLE DB 目标输入].ExternalColumns[提单号]"
                      dataType="wstr"
                      length="50"
                      name="提单号" />
                    <externalMetadataColumn
                      refId="Package\称重-签收分位数\90称重签收分位数.Inputs[OLE DB 目标输入].ExternalColumns[分位时间]"
                      dataType="numeric"
                      name="分位时间"
                      precision="17"
                      scale="6" />
                    <externalMetadataColumn
                      refId="Package\称重-签收分位数\90称重签收分位数.Inputs[OLE DB 目标输入].ExternalColumns[派送渠道名称]"
                      dataType="wstr"
                      length="64"
                      name="派送渠道名称" />
                  </externalMetadataColumns>
                </input>
              </inputs>
              <outputs>
                <output
                  refId="Package\称重-签收分位数\90称重签收分位数.Outputs[OLE DB 目标错误输出]"
                  exclusionGroup="1"
                  isErrorOut="true"
                  name="OLE DB 目标错误输出"
                  synchronousInputId="Package\称重-签收分位数\90称重签收分位数.Inputs[OLE DB 目标输入]">
                  <outputColumns>
                    <outputColumn
                      refId="Package\称重-签收分位数\90称重签收分位数.Outputs[OLE DB 目标错误输出].Columns[ErrorCode]"
                      dataType="i4"
                      lineageId="Package\称重-签收分位数\90称重签收分位数.Outputs[OLE DB 目标错误输出].Columns[ErrorCode]"
                      name="ErrorCode"
                      specialFlags="1" />
                    <outputColumn
                      refId="Package\称重-签收分位数\90称重签收分位数.Outputs[OLE DB 目标错误输出].Columns[ErrorColumn]"
                      dataType="i4"
                      lineageId="Package\称重-签收分位数\90称重签收分位数.Outputs[OLE DB 目标错误输出].Columns[ErrorColumn]"
                      name="ErrorColumn"
                      specialFlags="2" />
                  </outputColumns>
                  <externalMetadataColumns />
                </output>
              </outputs>
            </component>
            <component
              refId="Package\称重-签收分位数\95%称重签收分位数(提单)"
              componentClassID="Microsoft.OLEDBSource"
              contactInfo="OLE DB 源;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; 保留所有权利; http://www.microsoft.com/sql/support;7"
              description="OLE DB 源"
              name="95%称重签收分位数(提单)"
              usesDispositions="true"
              version="7">
              <properties>
                <property
                  dataType="System.Int32"
                  description="命令超时前等待的时间(秒)。值为 0，表示无限期等待。"
                  name="CommandTimeout">0</property>
                <property
                  dataType="System.String"
                  description="指定用于打开行集的数据库对象的名称。"
                  name="OpenRowset"></property>
                <property
                  dataType="System.String"
                  description="指定包含用于打开行集的数据库对象名的变量。"
                  name="OpenRowsetVariable"></property>
                <property
                  dataType="System.String"
                  description="要执行的 SQL 命令。"
                  name="SqlCommand"
                  UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor, Microsoft.DataTransformationServices.Controls, Version=16.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91">with t1 as(
select 
	 PERCENT_RANK() 
		over (  partition by a.LadingBillNumber,f.PublicName  
		order by  datediff(HOUR,e.ReceiveTime,d.signtime)/24.0) pr
	 ,datediff(HOUR,e.ReceiveTime,d.signtime)/24.0 as r,
	 a.LadingBillNumber,d.TrackingNumber,f.PublicName 
	from
  Logistics_LadingBill(nolock)a join Logistics_Box(nolock)b on a.LadingBillNumber=b.LadingBillNumber and a.IsDeleted=0 and b.IsDelete=0
	join Logistics_BoxDetail(nolock)c on c.BoxId=b.Id
	join Logistics_Trace(nolock)d on d.OrderId=c.OrderId 
	join Order_Order(nolock)e on e.id=d.OrderId
	join Logistics_Channel(nolock) f on f.id=e.ChannelId
	join Logistics_Channel(nolock)g on g.id=e.CreateOrderChannelId
	join Logistics_Public(nolock)h on h.Code=g.PublicCode
	where a.CreateTime&gt;'2022-05-01'
 )
 select  LadingBillNumber,PublicName Name,MIN(r)time from t1 where      pr&gt;=0.95
   group by LadingBillNumber,PublicName</property>
                <property
                  dataType="System.String"
                  description="包含要执行的 SQL 命令的变量。"
                  name="SqlCommandVariable"></property>
                <property
                  dataType="System.Int32"
                  description="指定当数据源中没有代码页信息时使用的列代码页。"
                  name="DefaultCodePage">936</property>
                <property
                  dataType="System.Boolean"
                  description="描述字符数据时，强制使用 DefaultCodePage 属性值。"
                  name="AlwaysUseDefaultCodePage">false</property>
                <property
                  dataType="System.Int32"
                  description="指定用于访问数据库的模式。"
                  name="AccessMode"
                  typeConverter="AccessMode">2</property>
                <property
                  dataType="System.String"
                  description="SQL 命令中的参数与变量之间的映射。"
                  name="ParameterMapping"></property>
              </properties>
              <connections>
                <connection
                  refId="Package\称重-签收分位数\95%称重签收分位数(提单).Connections[OleDbConnection]"
                  connectionManagerID="Package.ConnectionManagers[rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy1]"
                  connectionManagerRefId="Package.ConnectionManagers[rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy1]"
                  description="指定用于访问数据库的 OLE DB 运行时连接。"
                  name="OleDbConnection" />
              </connections>
              <outputs>
                <output
                  refId="Package\称重-签收分位数\95%称重签收分位数(提单).Outputs[OLE DB 源输出]"
                  name="OLE DB 源输出">
                  <outputColumns>
                    <outputColumn
                      refId="Package\称重-签收分位数\95%称重签收分位数(提单).Outputs[OLE DB 源输出].Columns[提单号]"
                      dataType="wstr"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\称重-签收分位数\95%称重签收分位数(提单).Outputs[OLE DB 源输出].ExternalColumns[LadingBillNumber]"
                      length="50"
                      lineageId="Package\称重-签收分位数\95%称重签收分位数(提单).Outputs[OLE DB 源输出].Columns[提单号]"
                      name="提单号"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\称重-签收分位数\95%称重签收分位数(提单).Outputs[OLE DB 源输出].Columns[分位时间]"
                      dataType="numeric"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\称重-签收分位数\95%称重签收分位数(提单).Outputs[OLE DB 源输出].ExternalColumns[time]"
                      lineageId="Package\称重-签收分位数\95%称重签收分位数(提单).Outputs[OLE DB 源输出].Columns[分位时间]"
                      name="分位时间"
                      precision="17"
                      scale="6"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\称重-签收分位数\95%称重签收分位数(提单).Outputs[OLE DB 源输出].Columns[派送渠道名称]"
                      dataType="wstr"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\称重-签收分位数\95%称重签收分位数(提单).Outputs[OLE DB 源输出].ExternalColumns[Name]"
                      length="64"
                      lineageId="Package\称重-签收分位数\95%称重签收分位数(提单).Outputs[OLE DB 源输出].Columns[派送渠道名称]"
                      name="派送渠道名称"
                      truncationRowDisposition="FailComponent" />
                  </outputColumns>
                  <externalMetadataColumns
                    isUsed="True">
                    <externalMetadataColumn
                      refId="Package\称重-签收分位数\95%称重签收分位数(提单).Outputs[OLE DB 源输出].ExternalColumns[LadingBillNumber]"
                      dataType="wstr"
                      length="50"
                      name="LadingBillNumber" />
                    <externalMetadataColumn
                      refId="Package\称重-签收分位数\95%称重签收分位数(提单).Outputs[OLE DB 源输出].ExternalColumns[time]"
                      dataType="numeric"
                      name="time"
                      precision="17"
                      scale="6" />
                    <externalMetadataColumn
                      refId="Package\称重-签收分位数\95%称重签收分位数(提单).Outputs[OLE DB 源输出].ExternalColumns[Name]"
                      dataType="wstr"
                      length="64"
                      name="Name" />
                  </externalMetadataColumns>
                </output>
                <output
                  refId="Package\称重-签收分位数\95%称重签收分位数(提单).Outputs[OLE DB 源错误输出]"
                  isErrorOut="true"
                  name="OLE DB 源错误输出">
                  <outputColumns>
                    <outputColumn
                      refId="Package\称重-签收分位数\95%称重签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[LadingBillNumber]"
                      dataType="wstr"
                      length="50"
                      lineageId="Package\称重-签收分位数\95%称重签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[LadingBillNumber]"
                      name="LadingBillNumber" />
                    <outputColumn
                      refId="Package\称重-签收分位数\95%称重签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[Name]"
                      dataType="wstr"
                      length="64"
                      lineageId="Package\称重-签收分位数\95%称重签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[Name]"
                      name="Name" />
                    <outputColumn
                      refId="Package\称重-签收分位数\95%称重签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[time]"
                      dataType="numeric"
                      lineageId="Package\称重-签收分位数\95%称重签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[time]"
                      name="time"
                      precision="17"
                      scale="6" />
                    <outputColumn
                      refId="Package\称重-签收分位数\95%称重签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[ErrorCode]"
                      dataType="i4"
                      lineageId="Package\称重-签收分位数\95%称重签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[ErrorCode]"
                      name="ErrorCode"
                      specialFlags="1" />
                    <outputColumn
                      refId="Package\称重-签收分位数\95%称重签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[ErrorColumn]"
                      dataType="i4"
                      lineageId="Package\称重-签收分位数\95%称重签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[ErrorColumn]"
                      name="ErrorColumn"
                      specialFlags="2" />
                  </outputColumns>
                  <externalMetadataColumns />
                </output>
              </outputs>
            </component>
            <component
              refId="Package\称重-签收分位数\98%称重签收分位数(提单)"
              componentClassID="Microsoft.OLEDBSource"
              contactInfo="OLE DB 源;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; 保留所有权利; http://www.microsoft.com/sql/support;7"
              description="OLE DB 源"
              name="98%称重签收分位数(提单)"
              usesDispositions="true"
              version="7">
              <properties>
                <property
                  dataType="System.Int32"
                  description="命令超时前等待的时间(秒)。值为 0，表示无限期等待。"
                  name="CommandTimeout">0</property>
                <property
                  dataType="System.String"
                  description="指定用于打开行集的数据库对象的名称。"
                  name="OpenRowset"></property>
                <property
                  dataType="System.String"
                  description="指定包含用于打开行集的数据库对象名的变量。"
                  name="OpenRowsetVariable"></property>
                <property
                  dataType="System.String"
                  description="要执行的 SQL 命令。"
                  name="SqlCommand"
                  UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor, Microsoft.DataTransformationServices.Controls, Version=16.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91">with t1 as(
select 
	 PERCENT_RANK() 
		over (  partition by a.LadingBillNumber,f.PublicName  
		order by  datediff(HOUR,e.ReceiveTime,d.signtime)/24.0) pr
	 ,datediff(HOUR,e.ReceiveTime,d.signtime)/24.0 as r,
	 a.LadingBillNumber,d.TrackingNumber,f.PublicName 
	from
  Logistics_LadingBill(nolock)a join Logistics_Box(nolock)b on a.LadingBillNumber=b.LadingBillNumber and a.IsDeleted=0 and b.IsDelete=0
	join Logistics_BoxDetail(nolock)c on c.BoxId=b.Id
	join Logistics_Trace(nolock)d on d.OrderId=c.OrderId 
	join Order_Order(nolock)e on e.id=d.OrderId
	join Logistics_Channel(nolock) f on f.id=e.ChannelId
	join Logistics_Channel(nolock)g on g.id=e.CreateOrderChannelId
	join Logistics_Public(nolock)h on h.Code=g.PublicCode
	where a.CreateTime&gt;'2022-05-01'
 )
 select  LadingBillNumber,PublicName Name,MIN(r)time from t1 where      pr&gt;=0.98
   group by LadingBillNumber,PublicName</property>
                <property
                  dataType="System.String"
                  description="包含要执行的 SQL 命令的变量。"
                  name="SqlCommandVariable"></property>
                <property
                  dataType="System.Int32"
                  description="指定当数据源中没有代码页信息时使用的列代码页。"
                  name="DefaultCodePage">936</property>
                <property
                  dataType="System.Boolean"
                  description="描述字符数据时，强制使用 DefaultCodePage 属性值。"
                  name="AlwaysUseDefaultCodePage">false</property>
                <property
                  dataType="System.Int32"
                  description="指定用于访问数据库的模式。"
                  name="AccessMode"
                  typeConverter="AccessMode">2</property>
                <property
                  dataType="System.String"
                  description="SQL 命令中的参数与变量之间的映射。"
                  name="ParameterMapping"></property>
              </properties>
              <connections>
                <connection
                  refId="Package\称重-签收分位数\98%称重签收分位数(提单).Connections[OleDbConnection]"
                  connectionManagerID="Package.ConnectionManagers[rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy1]"
                  connectionManagerRefId="Package.ConnectionManagers[rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy1]"
                  description="指定用于访问数据库的 OLE DB 运行时连接。"
                  name="OleDbConnection" />
              </connections>
              <outputs>
                <output
                  refId="Package\称重-签收分位数\98%称重签收分位数(提单).Outputs[OLE DB 源输出]"
                  name="OLE DB 源输出">
                  <outputColumns>
                    <outputColumn
                      refId="Package\称重-签收分位数\98%称重签收分位数(提单).Outputs[OLE DB 源输出].Columns[提单号]"
                      dataType="wstr"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\称重-签收分位数\98%称重签收分位数(提单).Outputs[OLE DB 源输出].ExternalColumns[LadingBillNumber]"
                      length="50"
                      lineageId="Package\称重-签收分位数\98%称重签收分位数(提单).Outputs[OLE DB 源输出].Columns[提单号]"
                      name="提单号"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\称重-签收分位数\98%称重签收分位数(提单).Outputs[OLE DB 源输出].Columns[分位时间]"
                      dataType="numeric"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\称重-签收分位数\98%称重签收分位数(提单).Outputs[OLE DB 源输出].ExternalColumns[time]"
                      lineageId="Package\称重-签收分位数\98%称重签收分位数(提单).Outputs[OLE DB 源输出].Columns[分位时间]"
                      name="分位时间"
                      precision="17"
                      scale="6"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\称重-签收分位数\98%称重签收分位数(提单).Outputs[OLE DB 源输出].Columns[派送渠道名称]"
                      dataType="wstr"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\称重-签收分位数\98%称重签收分位数(提单).Outputs[OLE DB 源输出].ExternalColumns[Name]"
                      length="64"
                      lineageId="Package\称重-签收分位数\98%称重签收分位数(提单).Outputs[OLE DB 源输出].Columns[派送渠道名称]"
                      name="派送渠道名称"
                      truncationRowDisposition="FailComponent" />
                  </outputColumns>
                  <externalMetadataColumns
                    isUsed="True">
                    <externalMetadataColumn
                      refId="Package\称重-签收分位数\98%称重签收分位数(提单).Outputs[OLE DB 源输出].ExternalColumns[LadingBillNumber]"
                      dataType="wstr"
                      length="50"
                      name="LadingBillNumber" />
                    <externalMetadataColumn
                      refId="Package\称重-签收分位数\98%称重签收分位数(提单).Outputs[OLE DB 源输出].ExternalColumns[time]"
                      dataType="numeric"
                      name="time"
                      precision="17"
                      scale="6" />
                    <externalMetadataColumn
                      refId="Package\称重-签收分位数\98%称重签收分位数(提单).Outputs[OLE DB 源输出].ExternalColumns[Name]"
                      dataType="wstr"
                      length="64"
                      name="Name" />
                  </externalMetadataColumns>
                </output>
                <output
                  refId="Package\称重-签收分位数\98%称重签收分位数(提单).Outputs[OLE DB 源错误输出]"
                  isErrorOut="true"
                  name="OLE DB 源错误输出">
                  <outputColumns>
                    <outputColumn
                      refId="Package\称重-签收分位数\98%称重签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[LadingBillNumber]"
                      dataType="wstr"
                      length="50"
                      lineageId="Package\称重-签收分位数\98%称重签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[LadingBillNumber]"
                      name="LadingBillNumber" />
                    <outputColumn
                      refId="Package\称重-签收分位数\98%称重签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[Name]"
                      dataType="wstr"
                      length="64"
                      lineageId="Package\称重-签收分位数\98%称重签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[Name]"
                      name="Name" />
                    <outputColumn
                      refId="Package\称重-签收分位数\98%称重签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[time]"
                      dataType="numeric"
                      lineageId="Package\称重-签收分位数\98%称重签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[time]"
                      name="time"
                      precision="17"
                      scale="6" />
                    <outputColumn
                      refId="Package\称重-签收分位数\98%称重签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[ErrorCode]"
                      dataType="i4"
                      lineageId="Package\称重-签收分位数\98%称重签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[ErrorCode]"
                      name="ErrorCode"
                      specialFlags="1" />
                    <outputColumn
                      refId="Package\称重-签收分位数\98%称重签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[ErrorColumn]"
                      dataType="i4"
                      lineageId="Package\称重-签收分位数\98%称重签收分位数(提单).Outputs[OLE DB 源错误输出].Columns[ErrorColumn]"
                      name="ErrorColumn"
                      specialFlags="2" />
                  </outputColumns>
                  <externalMetadataColumns />
                </output>
              </outputs>
            </component>
            <component
              refId="Package\称重-签收分位数\98称重签收分位数"
              componentClassID="Microsoft.OLEDBDestination"
              contactInfo="OLE DB 目标;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; 保留所有权利; http://www.microsoft.com/sql/support;4"
              description="OLE DB 目标"
              name="98称重签收分位数"
              usesDispositions="true"
              version="4">
              <properties>
                <property
                  dataType="System.Int32"
                  description="命令超时前等待的时间(秒)。值为 0，表示无限期等待。"
                  name="CommandTimeout">0</property>
                <property
                  dataType="System.String"
                  description="指定用于打开行集的数据库对象的名称。"
                  name="OpenRowset">[dbo].[BaseETL_98P_Ladding_DeliveryChanne_Weight]</property>
                <property
                  dataType="System.String"
                  description="指定包含用于打开行集的数据库对象名的变量。"
                  name="OpenRowsetVariable"></property>
                <property
                  dataType="System.String"
                  description="要执行的 SQL 命令。"
                  name="SqlCommand"
                  UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor, Microsoft.DataTransformationServices.Controls, Version=16.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"></property>
                <property
                  dataType="System.Int32"
                  description="指定当数据源中没有代码页信息时使用的列代码页。"
                  name="DefaultCodePage">936</property>
                <property
                  dataType="System.Boolean"
                  description="描述字符数据时，强制使用 DefaultCodePage 属性值。"
                  name="AlwaysUseDefaultCodePage">false</property>
                <property
                  dataType="System.Int32"
                  description="指定用于访问数据库的模式。"
                  name="AccessMode"
                  typeConverter="AccessMode">3</property>
                <property
                  dataType="System.Boolean"
                  description="指示是否将为标识列提供的值复制到目标。如果设置为 False，则将在目标中为标识列自动生成值。仅当启用了快速加载时适用。"
                  name="FastLoadKeepIdentity">false</property>
                <property
                  dataType="System.Boolean"
                  description="指示对于包含 Null 值的列是否将 Null 值插入目标中。如果为 False，则对于包含 Null 值的列会将其默认值插入目标中。仅当启用了快速加载时适用。"
                  name="FastLoadKeepNulls">false</property>
                <property
                  dataType="System.String"
                  description="指定将用于快速加载的选项。仅当启用了快速加载时适用。"
                  name="FastLoadOptions">TABLOCK,CHECK_CONSTRAINTS</property>
                <property
                  dataType="System.Int32"
                  description="指定在插入数据期间何时发出提交命令。如果值为 0，则指定在数据插入结束时发出一个提交命令。仅当启用了快速加载时适用。"
                  name="FastLoadMaxInsertCommitSize">2147483647</property>
              </properties>
              <connections>
                <connection
                  refId="Package\称重-签收分位数\98称重签收分位数.Connections[OleDbConnection]"
                  connectionManagerID="Package.ConnectionManagers[rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy1]"
                  connectionManagerRefId="Package.ConnectionManagers[rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy1]"
                  description="指定用于访问数据库的 OLE DB 运行时连接。"
                  name="OleDbConnection" />
              </connections>
              <inputs>
                <input
                  refId="Package\称重-签收分位数\98称重签收分位数.Inputs[OLE DB 目标输入]"
                  errorOrTruncationOperation="插入"
                  errorRowDisposition="FailComponent"
                  hasSideEffects="true"
                  name="OLE DB 目标输入">
                  <inputColumns>
                    <inputColumn
                      refId="Package\称重-签收分位数\98称重签收分位数.Inputs[OLE DB 目标输入].Columns[提单号]"
                      cachedDataType="wstr"
                      cachedLength="50"
                      cachedName="提单号"
                      externalMetadataColumnId="Package\称重-签收分位数\98称重签收分位数.Inputs[OLE DB 目标输入].ExternalColumns[提单号]"
                      lineageId="Package\称重-签收分位数\98%称重签收分位数(提单).Outputs[OLE DB 源输出].Columns[提单号]" />
                    <inputColumn
                      refId="Package\称重-签收分位数\98称重签收分位数.Inputs[OLE DB 目标输入].Columns[分位时间]"
                      cachedDataType="numeric"
                      cachedName="分位时间"
                      cachedPrecision="17"
                      cachedScale="6"
                      externalMetadataColumnId="Package\称重-签收分位数\98称重签收分位数.Inputs[OLE DB 目标输入].ExternalColumns[分位时间]"
                      lineageId="Package\称重-签收分位数\98%称重签收分位数(提单).Outputs[OLE DB 源输出].Columns[分位时间]" />
                    <inputColumn
                      refId="Package\称重-签收分位数\98称重签收分位数.Inputs[OLE DB 目标输入].Columns[派送渠道名称]"
                      cachedDataType="wstr"
                      cachedLength="64"
                      cachedName="派送渠道名称"
                      externalMetadataColumnId="Package\称重-签收分位数\98称重签收分位数.Inputs[OLE DB 目标输入].ExternalColumns[派送渠道名称]"
                      lineageId="Package\称重-签收分位数\98%称重签收分位数(提单).Outputs[OLE DB 源输出].Columns[派送渠道名称]" />
                  </inputColumns>
                  <externalMetadataColumns
                    isUsed="True">
                    <externalMetadataColumn
                      refId="Package\称重-签收分位数\98称重签收分位数.Inputs[OLE DB 目标输入].ExternalColumns[提单号]"
                      dataType="wstr"
                      length="50"
                      name="提单号" />
                    <externalMetadataColumn
                      refId="Package\称重-签收分位数\98称重签收分位数.Inputs[OLE DB 目标输入].ExternalColumns[分位时间]"
                      dataType="numeric"
                      name="分位时间"
                      precision="17"
                      scale="6" />
                    <externalMetadataColumn
                      refId="Package\称重-签收分位数\98称重签收分位数.Inputs[OLE DB 目标输入].ExternalColumns[派送渠道名称]"
                      dataType="wstr"
                      length="64"
                      name="派送渠道名称" />
                  </externalMetadataColumns>
                </input>
              </inputs>
              <outputs>
                <output
                  refId="Package\称重-签收分位数\98称重签收分位数.Outputs[OLE DB 目标错误输出]"
                  exclusionGroup="1"
                  isErrorOut="true"
                  name="OLE DB 目标错误输出"
                  synchronousInputId="Package\称重-签收分位数\98称重签收分位数.Inputs[OLE DB 目标输入]">
                  <outputColumns>
                    <outputColumn
                      refId="Package\称重-签收分位数\98称重签收分位数.Outputs[OLE DB 目标错误输出].Columns[ErrorCode]"
                      dataType="i4"
                      lineageId="Package\称重-签收分位数\98称重签收分位数.Outputs[OLE DB 目标错误输出].Columns[ErrorCode]"
                      name="ErrorCode"
                      specialFlags="1" />
                    <outputColumn
                      refId="Package\称重-签收分位数\98称重签收分位数.Outputs[OLE DB 目标错误输出].Columns[ErrorColumn]"
                      dataType="i4"
                      lineageId="Package\称重-签收分位数\98称重签收分位数.Outputs[OLE DB 目标错误输出].Columns[ErrorColumn]"
                      name="ErrorColumn"
                      specialFlags="2" />
                  </outputColumns>
                  <externalMetadataColumns />
                </output>
              </outputs>
            </component>
            <component
              refId="Package\称重-签收分位数\OLE DB 目标 1 1"
              componentClassID="Microsoft.OLEDBDestination"
              contactInfo="OLE DB 目标;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; 保留所有权利; http://www.microsoft.com/sql/support;4"
              description="OLE DB 目标"
              name="OLE DB 目标 1 1"
              usesDispositions="true"
              version="4">
              <properties>
                <property
                  dataType="System.Int32"
                  description="命令超时前等待的时间(秒)。值为 0，表示无限期等待。"
                  name="CommandTimeout">0</property>
                <property
                  dataType="System.String"
                  description="指定用于打开行集的数据库对象的名称。"
                  name="OpenRowset">[BaseETL_95P_Ladding_DeliveryChanne_Weight]</property>
                <property
                  dataType="System.String"
                  description="指定包含用于打开行集的数据库对象名的变量。"
                  name="OpenRowsetVariable"></property>
                <property
                  dataType="System.String"
                  description="要执行的 SQL 命令。"
                  name="SqlCommand"
                  UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor, Microsoft.DataTransformationServices.Controls, Version=16.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"></property>
                <property
                  dataType="System.Int32"
                  description="指定当数据源中没有代码页信息时使用的列代码页。"
                  name="DefaultCodePage">936</property>
                <property
                  dataType="System.Boolean"
                  description="描述字符数据时，强制使用 DefaultCodePage 属性值。"
                  name="AlwaysUseDefaultCodePage">false</property>
                <property
                  dataType="System.Int32"
                  description="指定用于访问数据库的模式。"
                  name="AccessMode"
                  typeConverter="AccessMode">3</property>
                <property
                  dataType="System.Boolean"
                  description="指示是否将为标识列提供的值复制到目标。如果设置为 False，则将在目标中为标识列自动生成值。仅当启用了快速加载时适用。"
                  name="FastLoadKeepIdentity">false</property>
                <property
                  dataType="System.Boolean"
                  description="指示对于包含 Null 值的列是否将 Null 值插入目标中。如果为 False，则对于包含 Null 值的列会将其默认值插入目标中。仅当启用了快速加载时适用。"
                  name="FastLoadKeepNulls">false</property>
                <property
                  dataType="System.String"
                  description="指定将用于快速加载的选项。仅当启用了快速加载时适用。"
                  name="FastLoadOptions">TABLOCK,CHECK_CONSTRAINTS</property>
                <property
                  dataType="System.Int32"
                  description="指定在插入数据期间何时发出提交命令。如果值为 0，则指定在数据插入结束时发出一个提交命令。仅当启用了快速加载时适用。"
                  name="FastLoadMaxInsertCommitSize">2147483647</property>
              </properties>
              <connections>
                <connection
                  refId="Package\称重-签收分位数\OLE DB 目标 1 1.Connections[OleDbConnection]"
                  connectionManagerID="Package.ConnectionManagers[rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy1]"
                  connectionManagerRefId="Package.ConnectionManagers[rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy1]"
                  description="指定用于访问数据库的 OLE DB 运行时连接。"
                  name="OleDbConnection" />
              </connections>
              <inputs>
                <input
                  refId="Package\称重-签收分位数\OLE DB 目标 1 1.Inputs[OLE DB 目标输入]"
                  errorOrTruncationOperation="插入"
                  errorRowDisposition="FailComponent"
                  hasSideEffects="true"
                  name="OLE DB 目标输入">
                  <inputColumns>
                    <inputColumn
                      refId="Package\称重-签收分位数\OLE DB 目标 1 1.Inputs[OLE DB 目标输入].Columns[提单号]"
                      cachedDataType="wstr"
                      cachedLength="50"
                      cachedName="提单号"
                      externalMetadataColumnId="Package\称重-签收分位数\OLE DB 目标 1 1.Inputs[OLE DB 目标输入].ExternalColumns[提单号]"
                      lineageId="Package\称重-签收分位数\95%称重签收分位数(提单).Outputs[OLE DB 源输出].Columns[提单号]" />
                    <inputColumn
                      refId="Package\称重-签收分位数\OLE DB 目标 1 1.Inputs[OLE DB 目标输入].Columns[分位时间]"
                      cachedDataType="numeric"
                      cachedName="分位时间"
                      cachedPrecision="17"
                      cachedScale="6"
                      externalMetadataColumnId="Package\称重-签收分位数\OLE DB 目标 1 1.Inputs[OLE DB 目标输入].ExternalColumns[分位时间]"
                      lineageId="Package\称重-签收分位数\95%称重签收分位数(提单).Outputs[OLE DB 源输出].Columns[分位时间]" />
                    <inputColumn
                      refId="Package\称重-签收分位数\OLE DB 目标 1 1.Inputs[OLE DB 目标输入].Columns[派送渠道名称]"
                      cachedDataType="wstr"
                      cachedLength="64"
                      cachedName="派送渠道名称"
                      externalMetadataColumnId="Package\称重-签收分位数\OLE DB 目标 1 1.Inputs[OLE DB 目标输入].ExternalColumns[派送渠道名称]"
                      lineageId="Package\称重-签收分位数\95%称重签收分位数(提单).Outputs[OLE DB 源输出].Columns[派送渠道名称]" />
                  </inputColumns>
                  <externalMetadataColumns
                    isUsed="True">
                    <externalMetadataColumn
                      refId="Package\称重-签收分位数\OLE DB 目标 1 1.Inputs[OLE DB 目标输入].ExternalColumns[提单号]"
                      dataType="wstr"
                      length="50"
                      name="提单号" />
                    <externalMetadataColumn
                      refId="Package\称重-签收分位数\OLE DB 目标 1 1.Inputs[OLE DB 目标输入].ExternalColumns[分位时间]"
                      dataType="numeric"
                      name="分位时间"
                      precision="17"
                      scale="6" />
                    <externalMetadataColumn
                      refId="Package\称重-签收分位数\OLE DB 目标 1 1.Inputs[OLE DB 目标输入].ExternalColumns[派送渠道名称]"
                      dataType="wstr"
                      length="64"
                      name="派送渠道名称" />
                  </externalMetadataColumns>
                </input>
              </inputs>
              <outputs>
                <output
                  refId="Package\称重-签收分位数\OLE DB 目标 1 1.Outputs[OLE DB 目标错误输出]"
                  exclusionGroup="1"
                  isErrorOut="true"
                  name="OLE DB 目标错误输出"
                  synchronousInputId="Package\称重-签收分位数\OLE DB 目标 1 1.Inputs[OLE DB 目标输入]">
                  <outputColumns>
                    <outputColumn
                      refId="Package\称重-签收分位数\OLE DB 目标 1 1.Outputs[OLE DB 目标错误输出].Columns[ErrorCode]"
                      dataType="i4"
                      lineageId="Package\称重-签收分位数\OLE DB 目标 1 1.Outputs[OLE DB 目标错误输出].Columns[ErrorCode]"
                      name="ErrorCode"
                      specialFlags="1" />
                    <outputColumn
                      refId="Package\称重-签收分位数\OLE DB 目标 1 1.Outputs[OLE DB 目标错误输出].Columns[ErrorColumn]"
                      dataType="i4"
                      lineageId="Package\称重-签收分位数\OLE DB 目标 1 1.Outputs[OLE DB 目标错误输出].Columns[ErrorColumn]"
                      name="ErrorColumn"
                      specialFlags="2" />
                  </outputColumns>
                  <externalMetadataColumns />
                </output>
              </outputs>
            </component>
          </components>
          <paths>
            <path
              refId="Package\称重-签收分位数.Paths[OLE DB 源输出]"
              endId="Package\称重-签收分位数\OLE DB 目标 1 1.Inputs[OLE DB 目标输入]"
              name="OLE DB 源输出"
              startId="Package\称重-签收分位数\95%称重签收分位数(提单).Outputs[OLE DB 源输出]" />
            <path
              refId="Package\称重-签收分位数.Paths[OLE DB 源输出1]"
              endId="Package\称重-签收分位数\90称重签收分位数.Inputs[OLE DB 目标输入]"
              name="OLE DB 源输出"
              startId="Package\称重-签收分位数\90%称重签收分位数(提单).Outputs[OLE DB 源输出]" />
            <path
              refId="Package\称重-签收分位数.Paths[OLE DB 源输出2]"
              endId="Package\称重-签收分位数\98称重签收分位数.Inputs[OLE DB 目标输入]"
              name="OLE DB 源输出"
              startId="Package\称重-签收分位数\98%称重签收分位数(提单).Outputs[OLE DB 源输出]" />
          </paths>
        </pipeline>
      </DTS:ObjectData>
    </DTS:Executable>
  </DTS:Executables>
  <DTS:PrecedenceConstraints>
    <DTS:PrecedenceConstraint
      DTS:refId="Package.PrecedenceConstraints[Constraint]"
      DTS:CreationName=""
      DTS:DTSID="{7486B693-64FB-481F-9DBD-FD486FC3A8B6}"
      DTS:From="Package\称重-签收分位数"
      DTS:LogicalAnd="True"
      DTS:ObjectName="Constraint"
      DTS:To="Package\上网-签收分位数" />
    <DTS:PrecedenceConstraint
      DTS:refId="Package.PrecedenceConstraints[Constraint 1]"
      DTS:CreationName=""
      DTS:DTSID="{565B2EE5-3B20-4E29-B659-EC4C37FFCE38}"
      DTS:From="Package\执行 SQL 任务"
      DTS:LogicalAnd="True"
      DTS:ObjectName="Constraint 1"
      DTS:To="Package\称重-签收分位数" />
  </DTS:PrecedenceConstraints>
  <DTS:DesignTimeProperties><![CDATA[<?xml version="1.0"?>
<!--This CDATA section contains the layout information of the package. The section includes information such as (x,y) coordinates, width, and height.-->
<!--If you manually edit this section and make a mistake, you can delete it. -->
<!--The package will still be able to load normally but the previous layout information will be lost and the designer will automatically re-arrange the elements on the design surface.-->
<Objects
  Version="8">
  <!--Each node below will contain properties that do not affect runtime behavior.-->
  <Package
    design-time-name="Package">
    <LayoutInfo>
      <GraphLayout
        Capacity="8" xmlns="clr-namespace:Microsoft.SqlServer.IntegrationServices.Designer.Model.Serialization;assembly=Microsoft.SqlServer.IntegrationServices.Graph" xmlns:mssgle="clr-namespace:Microsoft.SqlServer.Graph.LayoutEngine;assembly=Microsoft.SqlServer.Graph" xmlns:assembly="http://schemas.microsoft.com/winfx/2006/xaml">
        <NodeLayout
          Size="168.8,41.6"
          Id="Package\称重-签收分位数"
          TopLeft="238.333323862818,148.57142098096" />
        <NodeLayout
          Size="168.8,41.6"
          Id="Package\上网-签收分位数"
          TopLeft="237.499990562598,262.785700860073" />
        <NodeLayout
          Size="156.8,41.6"
          Id="Package\执行 SQL 任务"
          TopLeft="234.16665736172,48.285711818812" />
        <EdgeLayout
          Id="Package.PrecedenceConstraints[Constraint]"
          TopLeft="322.416657212708,190.57142098096">
          <EdgeLayout.Curve>
            <mssgle:Curve
              StartConnector="{assembly:Null}"
              EndConnector="0,72.214279879113"
              Start="0,0"
              End="0,64.714279879113">
              <mssgle:Curve.Segments>
                <mssgle:SegmentCollection
                  Capacity="5">
                  <mssgle:LineSegment
                    End="0,64.714279879113" />
                </mssgle:SegmentCollection>
              </mssgle:Curve.Segments>
            </mssgle:Curve>
          </EdgeLayout.Curve>
          <EdgeLayout.Labels>
            <EdgeLabelCollection />
          </EdgeLayout.Labels>
        </EdgeLayout>
        <EdgeLayout
          Id="Package.PrecedenceConstraints[Constraint 1]"
          TopLeft="312.66665736172,90.285711818812">
          <EdgeLayout.Curve>
            <mssgle:Curve
              StartConnector="{assembly:Null}"
              EndConnector="10.1666665010978,58.285709162148"
              Start="0,0"
              End="10.1666665010978,50.785709162148">
              <mssgle:Curve.Segments>
                <mssgle:SegmentCollection
                  Capacity="5">
                  <mssgle:LineSegment
                    End="0,25.142854581074" />
                  <mssgle:CubicBezierSegment
                    Point1="0,25.142854581074"
                    Point2="0,29.142854581074"
                    Point3="4,29.142854581074" />
                  <mssgle:LineSegment
                    End="6.16666650109778,29.142854581074" />
                  <mssgle:CubicBezierSegment
                    Point1="6.16666650109778,29.142854581074"
                    Point2="10.1666665010978,29.142854581074"
                    Point3="10.1666665010978,33.142854581074" />
                  <mssgle:LineSegment
                    End="10.1666665010978,50.785709162148" />
                </mssgle:SegmentCollection>
              </mssgle:Curve.Segments>
            </mssgle:Curve>
          </EdgeLayout.Curve>
          <EdgeLayout.Labels>
            <EdgeLabelCollection />
          </EdgeLayout.Labels>
        </EdgeLayout>
      </GraphLayout>
    </LayoutInfo>
  </Package>
  <TaskHost
    design-time-name="Package\称重-签收分位数">
    <LayoutInfo>
      <GraphLayout
        Capacity="16" xmlns="clr-namespace:Microsoft.SqlServer.IntegrationServices.Designer.Model.Serialization;assembly=Microsoft.SqlServer.IntegrationServices.Graph" xmlns:mssgle="clr-namespace:Microsoft.SqlServer.Graph.LayoutEngine;assembly=Microsoft.SqlServer.Graph" xmlns:assembly="http://schemas.microsoft.com/winfx/2006/xaml">
        <NodeLayout
          Size="168.8,89.6"
          Id="Package\称重-签收分位数\95%称重签收分位数(提单)"
          TopLeft="323.458331502767,60.7222222030899" />
        <NodeLayout
          Size="174.4,41.6"
          Id="Package\称重-签收分位数\98称重签收分位数"
          TopLeft="343.749994877726,469.444432008414" />
        <NodeLayout
          Size="174.4,41.6"
          Id="Package\称重-签收分位数\90称重签收分位数"
          TopLeft="694.374989653006,233.277771598027" />
        <NodeLayout
          Size="216.8,41.6"
          Id="Package\称重-签收分位数\98%称重签收分位数(提单)"
          TopLeft="355.624994700775,344.499990873867" />
        <NodeLayout
          Size="216.8,41.6"
          Id="Package\称重-签收分位数\90%称重签收分位数(提单)"
          TopLeft="685.624989783391,64.999998278088" />
        <NodeLayout
          Size="156.8,41.6"
          Id="Package\称重-签收分位数\OLE DB 目标 1 1"
          TopLeft="368.666663024161,241.999990701676" />
        <EdgeLayout
          Id="Package\称重-签收分位数.Paths[OLE DB 源输出2]"
          TopLeft="464.024994700775,386.099990873867">
          <EdgeLayout.Curve>
            <mssgle:Curve
              StartConnector="{assembly:Null}"
              EndConnector="-33.0749998230486,83.344441134547"
              Start="0,0"
              End="-33.0749998230486,75.844441134547">
              <mssgle:Curve.Segments>
                <mssgle:SegmentCollection
                  Capacity="5">
                  <mssgle:LineSegment
                    End="0,37.6722205672735" />
                  <mssgle:CubicBezierSegment
                    Point1="0,37.6722205672735"
                    Point2="0,41.6722205672735"
                    Point3="-4,41.6722205672735" />
                  <mssgle:LineSegment
                    End="-29.0749998230486,41.6722205672735" />
                  <mssgle:CubicBezierSegment
                    Point1="-29.0749998230486,41.6722205672735"
                    Point2="-33.0749998230486,41.6722205672735"
                    Point3="-33.0749998230486,45.6722205672735" />
                  <mssgle:LineSegment
                    End="-33.0749998230486,75.844441134547" />
                </mssgle:SegmentCollection>
              </mssgle:Curve.Segments>
            </mssgle:Curve>
          </EdgeLayout.Curve>
          <EdgeLayout.Labels>
            <EdgeLabelCollection />
          </EdgeLayout.Labels>
        </EdgeLayout>
        <EdgeLayout
          Id="Package\称重-签收分位数.Paths[OLE DB 源输出1]"
          TopLeft="794.024989783391,106.599998278088">
          <EdgeLayout.Curve>
            <mssgle:Curve
              StartConnector="{assembly:Null}"
              EndConnector="-12.4500001303852,126.677773319939"
              Start="0,0"
              End="-12.4500001303852,119.177773319939">
              <mssgle:Curve.Segments>
                <mssgle:SegmentCollection
                  Capacity="5">
                  <mssgle:LineSegment
                    End="0,59.3388866599696" />
                  <mssgle:CubicBezierSegment
                    Point1="0,59.3388866599696"
                    Point2="0,63.3388866599696"
                    Point3="-4,63.3388866599696" />
                  <mssgle:LineSegment
                    End="-8.45000013038521,63.3388866599696" />
                  <mssgle:CubicBezierSegment
                    Point1="-8.45000013038521,63.3388866599696"
                    Point2="-12.4500001303852,63.3388866599696"
                    Point3="-12.4500001303852,67.3388866599696" />
                  <mssgle:LineSegment
                    End="-12.4500001303852,119.177773319939" />
                </mssgle:SegmentCollection>
              </mssgle:Curve.Segments>
            </mssgle:Curve>
          </EdgeLayout.Curve>
          <EdgeLayout.Labels>
            <EdgeLabelCollection />
          </EdgeLayout.Labels>
        </EdgeLayout>
        <EdgeLayout
          Id="Package\称重-签收分位数.Paths[OLE DB 源输出]"
          TopLeft="407.858331502767,150.32222220309">
          <EdgeLayout.Curve>
            <mssgle:Curve
              StartConnector="{assembly:Null}"
              EndConnector="39.2083315213943,91.6777684985861"
              Start="0,0"
              End="39.2083315213943,84.1777684985861">
              <mssgle:Curve.Segments>
                <mssgle:SegmentCollection
                  Capacity="5">
                  <mssgle:LineSegment
                    End="0,41.838884249293" />
                  <mssgle:CubicBezierSegment
                    Point1="0,41.838884249293"
                    Point2="0,45.838884249293"
                    Point3="4,45.838884249293" />
                  <mssgle:LineSegment
                    End="35.2083315213943,45.838884249293" />
                  <mssgle:CubicBezierSegment
                    Point1="35.2083315213943,45.838884249293"
                    Point2="39.2083315213943,45.838884249293"
                    Point3="39.2083315213943,49.838884249293" />
                  <mssgle:LineSegment
                    End="39.2083315213943,84.1777684985861" />
                </mssgle:SegmentCollection>
              </mssgle:Curve.Segments>
            </mssgle:Curve>
          </EdgeLayout.Curve>
          <EdgeLayout.Labels>
            <EdgeLabelCollection />
          </EdgeLayout.Labels>
        </EdgeLayout>
      </GraphLayout>
    </LayoutInfo>
  </TaskHost>
  <PipelineComponentMetadata
    design-time-name="Package\称重-签收分位数\95%称重签收分位数(提单)">
    <Properties>
      <Property>
        <Name>DataSourceViewID</Name>
      </Property>
    </Properties>
  </PipelineComponentMetadata>
  <PipelineComponentMetadata
    design-time-name="Package\称重-签收分位数\98称重签收分位数">
    <Properties>
      <Property>
        <Name>DataSourceViewID</Name>
      </Property>
      <Property>
        <Name>TableInfoObjectType</Name>
        <Value
          type="q2:string">Table</Value>
      </Property>
    </Properties>
  </PipelineComponentMetadata>
  <PipelineComponentMetadata
    design-time-name="Package\称重-签收分位数\90称重签收分位数">
    <Properties>
      <Property>
        <Name>DataSourceViewID</Name>
      </Property>
      <Property>
        <Name>TableInfoObjectType</Name>
        <Value
          type="q2:string">Table</Value>
      </Property>
    </Properties>
  </PipelineComponentMetadata>
  <PipelineComponentMetadata
    design-time-name="Package\称重-签收分位数\98%称重签收分位数(提单)">
    <Properties>
      <Property>
        <Name>DataSourceViewID</Name>
      </Property>
    </Properties>
  </PipelineComponentMetadata>
  <PipelineComponentMetadata
    design-time-name="Package\称重-签收分位数\90%称重签收分位数(提单)">
    <Properties>
      <Property>
        <Name>DataSourceViewID</Name>
      </Property>
    </Properties>
  </PipelineComponentMetadata>
  <PipelineComponentMetadata
    design-time-name="Package\称重-签收分位数\OLE DB 目标 1 1">
    <Properties>
      <Property>
        <Name>DataSourceViewID</Name>
      </Property>
      <Property>
        <Name>TableInfoObjectType</Name>
        <Value
          type="q2:string">Table</Value>
      </Property>
    </Properties>
  </PipelineComponentMetadata>
  <TaskHost
    design-time-name="Package\上网-签收分位数">
    <LayoutInfo>
      <GraphLayout
        Capacity="4" xmlns="clr-namespace:Microsoft.SqlServer.IntegrationServices.Designer.Model.Serialization;assembly=Microsoft.SqlServer.IntegrationServices.Graph" xmlns:mssgle="clr-namespace:Microsoft.SqlServer.Graph.LayoutEngine;assembly=Microsoft.SqlServer.Graph" xmlns:assembly="http://schemas.microsoft.com/winfx/2006/xaml">
        <NodeLayout
          Size="156.8,41.6"
          Id="Package\上网-签收分位数\OLE DB 目标 1"
          TopLeft="105.83333151208,241.999990701676" />
        <NodeLayout
          Size="168.8,89.6"
          Id="Package\上网-签收分位数\95%上网签收分位数(提单)"
          TopLeft="60,60" />
        <EdgeLayout
          Id="Package\上网-签收分位数.Paths[OLE DB 源输出]"
          TopLeft="144.5,150">
          <EdgeLayout.Curve>
            <mssgle:Curve
              StartConnector="{assembly:Null}"
              EndConnector="39.8333315120803,91.9999907016759"
              Start="0,0"
              End="39.8333315120803,84.4999907016759">
              <mssgle:Curve.Segments>
                <mssgle:SegmentCollection
                  Capacity="5">
                  <mssgle:LineSegment
                    End="0,41.999995350838" />
                  <mssgle:CubicBezierSegment
                    Point1="0,41.999995350838"
                    Point2="0,45.999995350838"
                    Point3="4,45.999995350838" />
                  <mssgle:LineSegment
                    End="35.8333315120803,45.999995350838" />
                  <mssgle:CubicBezierSegment
                    Point1="35.8333315120803,45.999995350838"
                    Point2="39.8333315120803,45.999995350838"
                    Point3="39.8333315120803,49.999995350838" />
                  <mssgle:LineSegment
                    End="39.8333315120803,84.4999907016759" />
                </mssgle:SegmentCollection>
              </mssgle:Curve.Segments>
            </mssgle:Curve>
          </EdgeLayout.Curve>
          <EdgeLayout.Labels>
            <EdgeLabelCollection />
          </EdgeLayout.Labels>
        </EdgeLayout>
      </GraphLayout>
    </LayoutInfo>
  </TaskHost>
  <PipelineComponentMetadata
    design-time-name="Package\上网-签收分位数\95%上网签收分位数(提单)">
    <Properties>
      <Property>
        <Name>DataSourceViewID</Name>
      </Property>
    </Properties>
  </PipelineComponentMetadata>
  <PipelineComponentMetadata
    design-time-name="Package\上网-签收分位数\OLE DB 目标 1">
    <Properties>
      <Property>
        <Name>DataSourceViewID</Name>
      </Property>
      <Property>
        <Name>TableInfoObjectType</Name>
        <Value
          type="q2:string">Table</Value>
      </Property>
    </Properties>
  </PipelineComponentMetadata>
</Objects>]]></DTS:DesignTimeProperties>
</DTS:Executable>