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 4:26:54 PM"
  DTS:CreationName="Microsoft.Package"
  DTS:CreatorComputerName="FAN"
  DTS:CreatorName="FAN\dell"
  DTS:DTSID="{9EDD08B4-6A6E-4762-B256-469793ABB901}"
  DTS:ExecutableType="Microsoft.Package"
  DTS:LastModifiedProductVersion="16.0.694.0"
  DTS:LocaleID="2052"
  DTS:ObjectName="Package1"
  DTS:PackageType="5"
  DTS:VersionBuild="50"
  DTS:VersionGUID="{0DC55AB1-46B6-4AC1-9657-57D283C3AA06}">
  <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="{0175D2E7-B39E-479C-BC7C-1CFA636880F1}"
      DTS:ObjectName="rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy1">
      <DTS:ObjectData>
        <DTS:ConnectionManager
          DTS:ConnectRetryCount="1"
          DTS:ConnectRetryInterval="5"
          DTS:ConnectUsingManagedIdentity="True"
          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-{0175D2E7-B39E-479C-BC7C-1CFA636880F1}rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy1;">
          <DTS:Password
            DTS:Name="Password"
            Sensitive="1"
            Encrypted="1">AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAjatZAapyo0SdzktcY+dJrgAAAAAIAAAARABUAFMAAAAQZgAAAAEAACAAAACrEZHXr+UYkjiHkGEvwgSmrcBnnI8ExX39GxkqNKGpyAAAAAAOgAAAAAIAACAAAAAMG0hkxePKJ1Q05LCkj8zhA7KyqGkCenXjgxKQeeCAyDAAAABTVvuvePAfYbDEvi8ypverHJhLyBBlFhaLk1URFTXHZSA3pvlOAUtcaMCOtlyCVFdAAAAA4+BuLz4MTP4Gb4jNLv//qrfRCzqEXILgutEMESdX/QeEUAquOAUm+/ET2PTLb124BvdPp77otmA1OZdoj8N7cg</DTS:Password>
        </DTS:ConnectionManager>
      </DTS:ObjectData>
    </DTS:ConnectionManager>
    <DTS:ConnectionManager
      DTS:refId="Package.ConnectionManagers[rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy1 1]"
      DTS:CreationName="OLEDB"
      DTS:DelayValidation="True"
      DTS:DTSID="{7F33CAB4-7A54-49E5-BE7B-48948B0BD91C}"
      DTS:ObjectName="rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy1 1">
      <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-{7F33CAB4-7A54-49E5-BE7B-48948B0BD91C}rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy1 1;">
          <DTS:Password
            DTS:Name="Password"
            Sensitive="1"
            Encrypted="1">AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAjatZAapyo0SdzktcY+dJrgAAAAAIAAAARABUAFMAAAAQZgAAAAEAACAAAABQRUq3R6jHoiGFawKd5H+aTWaXyJZbJ3nMxeSLac7IcAAAAAAOgAAAAAIAACAAAACkBY250380L/S7ykiX/ZNtjI6UUVyAd3dAnZ75kABsijAAAAD/moRFD2gN1ATRJOVFQ1koVncAHJePRmGiLqZNH7j7DoQXiXNdBnXRHJsVp8m3M1lAAAAAV1oMacCWkuHvCVWRhP17gTI0yBx5kkcaXRC1wKAAizqPdCgAfSo4KsKMOlPDSW9N8qw2PvBcj9pxVpqKm2v/Bw</DTS:Password>
        </DTS:ConnectionManager>
      </DTS:ObjectData>
    </DTS:ConnectionManager>
  </DTS:ConnectionManagers>
  <DTS:Variables />
  <DTS:Executables>
    <DTS:Executable
      DTS:refId="Package\执行 SQL 任务"
      DTS:CreationName="Microsoft.ExecuteSQLTask"
      DTS:Description="执行 SQL 任务"
      DTS:DTSID="{C716DBD4-AF26-4012-9EAE-85C2B9B5CE85}"
      DTS:ExecutableType="Microsoft.ExecuteSQLTask"
      DTS:LocaleID="-1"
      DTS:ObjectName="执行 SQL 任务"
      DTS:ThreadHint="0">
      <DTS:Variables />
      <DTS:ObjectData>
        <SQLTask:SqlTaskData
          SQLTask:Connection="{7F33CAB4-7A54-49E5-BE7B-48948B0BD91C}"
          SQLTask:SqlStatementSource="Truncate table [渠道报表基础数据]" 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="{3C52E982-0572-4682-B8A2-99ED2CD0045D}"
      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\数据流任务\OLE DB 源"
              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="OLE DB 源"
              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">--提单号、服务渠道、下单渠道、分区、州/省、出货日期、口岸、代理
--上网票数、签收票数、出货票数、收货重量、2-3内上网票数、称重-签收、N-N时效内票数、出货日期、起飞时间、落地时间、第一票上网时间

select c.LadingBillNumber[提单号],
		a.实际派送渠道 ,
	    case when 	a.渠道名称 = '美国快线YSW' then '美国快线' else a.渠道名称 end as [渠道名称],
		a.末端分区,
		a.所属客户,
		isnull(f.Name,a.州名) as 州名,
		CONVERT(nvarchar(10),d.LeaveWarehouseTime,120)[出货日期],
		CONVERT(nvarchar(10),a.称重时间,120)[收货日期],
		convert(nvarchar(10),d.DepartTime,120)[起飞日期],
		convert(nvarchar(16),d.ArrivalTime,120)[落地日期],
		convert(nvarchar(16),d.ClearanceTime,120)[提取日期],
		min(e.OnlineTime)[第一票上网时间],
		d.Destination[口岸],
		d.ServiceName[代理],
		sum(case when e.OnlineTime is not null then 1 else 0 end)[上网票数],
		sum(case when e.signtime is not null then 1 else 0 end)[签收票数],
		sum(case when e.SignTime is not null then ceiling(datediff(DAY,a.称重时间,e.SignTime)) else 0 end) [总时效],
		count(0)[出货票数],
		sum(a.称重重量/1000.0)[收货重量],
		sum(case when e.OnlineDay&lt;=2 then 1 else 0 end)[_2天内上网票数],
		sum(case when e.OnlineDay&lt;=3 then 1 else 0 end)[_3天内上网票数],
		sum(case when ceiling(datediff(HOUR,a.称重时间,e.SignTime) / 24.0)&lt;=5 then 1 else 0 end)[_5天内称重至签收],
		sum(case when ceiling(datediff(HOUR,a.称重时间,e.SignTime) / 24.0)&lt;=6 then 1 else 0 end)[_6天内称重至签收],
		sum(case when ceiling(datediff(HOUR,a.称重时间,e.SignTime) / 24.0)&lt;=7 then 1 else 0 end)[_7天内称重至签收],
		sum(case when ceiling(datediff(HOUR,a.称重时间,e.SignTime) / 24.0)&lt;=8 then 1 else 0 end)[_8天内称重至签收],
		sum(case when ceiling(datediff(HOUR,a.称重时间,e.SignTime) / 24.0)&lt;=9 then 1 else 0 end)[_9天内称重至签收],
		sum(case when ceiling(datediff(HOUR,a.称重时间,e.SignTime) / 24.0)&lt;=10 then 1 else 0 end)[_10天内称重至签收],
		sum(case when ceiling(datediff(HOUR,a.称重时间,e.SignTime) / 24.0)&lt;=11 then 1 else 0 end)[_11天内称重至签收],
		sum(case when ceiling(datediff(HOUR,a.称重时间,e.SignTime) / 24.0)&lt;=12 then 1 else 0 end)[_12天内称重至签收],
		sum(case when ceiling(datediff(HOUR,a.称重时间,e.SignTime) / 24.0)&lt;=13 then 1 else 0 end)[_13天内称重至签收],
		sum(case when ceiling(datediff(HOUR,a.称重时间,e.SignTime) / 24.0)&lt;=14 then 1 else 0 end)[_14天内称重至签收],
		sum(case when ceiling(datediff(HOUR,a.称重时间,e.SignTime) / 24.0)&lt;=15 then 1 else 0 end)[_15天内称重至签收],
		sum(case when ceiling(datediff(HOUR,a.称重时间,e.SignTime) / 24.0)&lt;=16 then 1 else 0 end)[_16天内称重至签收],
		sum(case when ceiling(datediff(HOUR,a.称重时间,e.SignTime) / 24.0)&lt;=17 then 1 else 0 end)[_17天内称重至签收],
		sum(case when ceiling(datediff(HOUR,a.称重时间,e.SignTime) / 24.0)&lt;=18 then 1 else 0 end)[_18天内称重至签收],
		sum(case when ceiling(datediff(HOUR,a.称重时间,e.SignTime) / 24.0)&lt;=19 then 1 else 0 end)[_19天内称重至签收],
		sum(case when ceiling(datediff(HOUR,a.称重时间,e.SignTime) / 24.0)&lt;=20 then 1 else 0 end)[_20天内称重至签收],
		sum(case when ceiling(datediff(HOUR,a.称重时间,e.SignTime) / 24.0)&lt;=21 then 1 else 0 end)[_21天内称重至签收],
		sum(case when ceiling(datediff(HOUR,a.称重时间,e.SignTime) / 24.0)&lt;=22 then 1 else 0 end)[_22天内称重至签收],
		sum(case when ceiling(datediff(HOUR,a.称重时间,e.SignTime) / 24.0)&lt;=23 then 1 else 0 end)[_23天内称重至签收],
		sum(case when ceiling(datediff(HOUR,a.称重时间,e.SignTime) / 24.0)&lt;=24 then 1 else 0 end)[_24天内称重至签收],
		sum(case when ceiling(datediff(HOUR,a.称重时间,e.SignTime) / 24.0)&lt;=25 then 1 else 0 end)[_25天内称重至签收],
		sum(case when ceiling(datediff(HOUR,a.称重时间,e.SignTime) / 24.0)&gt;25 then 1 else 0 end)[_超过25天称重至签收],
		sum(case when ceiling(datediff(HOUR,e.OnlineTime,e.SignTime) / 24.0)&lt;=4 then 1 else 0 end)[_4天内上网至签收],
		sum(case when ceiling(datediff(HOUR,e.OnlineTime,e.SignTime) / 24.0)&lt;=5 then 1 else 0 end)[_5天内上网至签收],
		sum(case when ceiling(datediff(HOUR,e.OnlineTime,e.SignTime) / 24.0)&lt;=6 then 1 else 0 end)[_6天内上网至签收],
		sum(case when ceiling(datediff(HOUR,e.OnlineTime,e.SignTime) / 24.0)&lt;=7 then 1 else 0 end)[_7天内上网至签收],
		sum(case when ceiling(datediff(HOUR,e.OnlineTime,e.SignTime) / 24.0)&lt;=8 then 1 else 0 end)[_8天内上网至签收],
		sum(case when ceiling(datediff(HOUR,e.OnlineTime,e.SignTime) / 24.0)&lt;=9 then 1 else 0 end)[_9天内上网至签收],
		sum(case when ceiling(datediff(HOUR,e.OnlineTime,e.SignTime) / 24.0)&lt;=10 then 1 else 0 end)[_10天内上网至签收],
		sum(case when ceiling(datediff(HOUR,e.OnlineTime,e.SignTime) / 24.0)&lt;=11 then 1 else 0 end)[_11天内上网至签收],
		sum(case when ceiling(datediff(HOUR,e.OnlineTime,e.SignTime) / 24.0)&lt;=12 then 1 else 0 end)[_12天内上网至签收],
		sum(case when ceiling(datediff(HOUR,e.OnlineTime,e.SignTime) / 24.0)&lt;=13 then 1 else 0 end)[_13天内上网至签收],
		sum(case when ceiling(datediff(HOUR,e.OnlineTime,e.SignTime) / 24.0)&lt;=14 then 1 else 0 end)[_14天内上网至签收],
		sum(case when ceiling(datediff(HOUR,e.OnlineTime,e.SignTime) / 24.0)&lt;=15 then 1 else 0 end)[_15天内上网至签收],
		sum(case when ceiling(datediff(HOUR,e.OnlineTime,e.SignTime) / 24.0)&lt;=16 then 1 else 0 end)[_16天内上网至签收],
		sum(case when ceiling(datediff(HOUR,e.OnlineTime,e.SignTime) / 24.0)&lt;=17 then 1 else 0 end)[_17天内上网至签收],
		sum(case when ceiling(datediff(HOUR,e.OnlineTime,e.SignTime) / 24.0)&lt;=18 then 1 else 0 end)[_18天内上网至签收],
		sum(case when ceiling(datediff(HOUR,e.OnlineTime,e.SignTime) / 24.0)&lt;=19 then 1 else 0 end)[_19天内上网至签收],
		sum(case when ceiling(datediff(HOUR,e.OnlineTime,e.SignTime) / 24.0)&lt;=20 then 1 else 0 end)[_20天内上网至签收],
		sum(case when ceiling(datediff(HOUR,e.OnlineTime,e.SignTime) / 24.0)&gt;20 then 1 else 0 end)[_超过20天上网至签收]
	from BaseOrderInfo(nolock) a
	left join Logistics_BoxDetail(nolock)b on a.OrderId=b.OrderId
	left join logistics_box(nolock)c on c.Id=b.BoxId and c.IsDelete=0
	left join Logistics_LadingBill(nolock)d on d.LadingBillNumber=c.LadingBillNumber and d.IsDeleted = 0
	left join Logistics_Trace(nolock)e on e.OrderId=a.OrderId
 left join state_codes(nolock)f on a.州名=f.code and a.目的国家= f.CountryCode
where  d.LeaveWarehouseTime &gt;'2022-08-01' 
group by
c.LadingBillNumber,
a.实际派送渠道 ,
a.渠道名称,
a.末端分区,
a.所属客户,
isnull(f.Name,a.州名),
d.Destination,
d.ServiceName,
CONVERT(nvarchar(10),d.LeaveWarehouseTime,120),
CONVERT(nvarchar(10),a.称重时间,120),
convert(nvarchar(10),d.DepartTime,120),
convert(nvarchar(16),d.ArrivalTime,120),
convert(nvarchar(16),d.ClearanceTime,120)</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\数据流任务\OLE DB 源.Connections[OleDbConnection]"
                  connectionManagerID="Package.ConnectionManagers[rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy1 1]"
                  connectionManagerRefId="Package.ConnectionManagers[rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy1 1]"
                  description="指定用于访问数据库的 OLE DB 运行时连接。"
                  name="OleDbConnection" />
              </connections>
              <outputs>
                <output
                  refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出]"
                  name="OLE DB 源输出">
                  <outputColumns>
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[提单号]"
                      dataType="wstr"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[提单号]"
                      length="50"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[提单号]"
                      name="提单号"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[实际派送渠道]"
                      dataType="wstr"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[实际派送渠道]"
                      length="64"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[实际派送渠道]"
                      name="实际派送渠道"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[渠道名称]"
                      dataType="wstr"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[渠道名称]"
                      length="50"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[渠道名称]"
                      name="渠道名称"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[末端分区]"
                      dataType="wstr"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[末端分区]"
                      length="50"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[末端分区]"
                      name="末端分区"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[州名]"
                      dataType="wstr"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[州名]"
                      length="128"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[州名]"
                      name="州名"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[出货日期]"
                      dataType="wstr"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[出货日期]"
                      length="10"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[出货日期]"
                      name="出货日期"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[起飞日期]"
                      dataType="wstr"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[起飞日期]"
                      length="10"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[起飞日期]"
                      name="起飞日期"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[第一票上网时间]"
                      dataType="dbTimeStamp"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[第一票上网时间]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[第一票上网时间]"
                      name="第一票上网时间"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[口岸]"
                      dataType="wstr"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[口岸]"
                      length="64"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[口岸]"
                      name="口岸"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[代理]"
                      dataType="wstr"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[代理]"
                      length="64"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[代理]"
                      name="代理"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[上网票数]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[上网票数]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[上网票数]"
                      name="上网票数"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[签收票数]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[签收票数]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[签收票数]"
                      name="签收票数"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[出货票数]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[出货票数]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[出货票数]"
                      name="出货票数"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[收货重量]"
                      dataType="numeric"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[收货重量]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[收货重量]"
                      name="收货重量"
                      precision="38"
                      scale="6"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_2天内上网票数]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_2天内上网票数]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_2天内上网票数]"
                      name="_2天内上网票数"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_3天内上网票数]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_3天内上网票数]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_3天内上网票数]"
                      name="_3天内上网票数"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_5天内称重至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_5天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_5天内称重至签收]"
                      name="_5天内称重至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_6天内称重至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_6天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_6天内称重至签收]"
                      name="_6天内称重至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_7天内称重至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_7天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_7天内称重至签收]"
                      name="_7天内称重至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_8天内称重至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_8天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_8天内称重至签收]"
                      name="_8天内称重至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_9天内称重至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_9天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_9天内称重至签收]"
                      name="_9天内称重至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_10天内称重至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_10天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_10天内称重至签收]"
                      name="_10天内称重至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_11天内称重至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_11天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_11天内称重至签收]"
                      name="_11天内称重至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_12天内称重至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_12天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_12天内称重至签收]"
                      name="_12天内称重至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_13天内称重至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_13天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_13天内称重至签收]"
                      name="_13天内称重至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_14天内称重至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_14天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_14天内称重至签收]"
                      name="_14天内称重至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_15天内称重至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_15天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_15天内称重至签收]"
                      name="_15天内称重至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_16天内称重至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_16天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_16天内称重至签收]"
                      name="_16天内称重至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_17天内称重至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_17天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_17天内称重至签收]"
                      name="_17天内称重至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_18天内称重至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_18天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_18天内称重至签收]"
                      name="_18天内称重至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_19天内称重至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_19天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_19天内称重至签收]"
                      name="_19天内称重至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_20天内称重至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_20天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_20天内称重至签收]"
                      name="_20天内称重至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_21天内称重至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_21天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_21天内称重至签收]"
                      name="_21天内称重至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_22天内称重至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_22天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_22天内称重至签收]"
                      name="_22天内称重至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_23天内称重至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_23天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_23天内称重至签收]"
                      name="_23天内称重至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_24天内称重至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_24天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_24天内称重至签收]"
                      name="_24天内称重至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_25天内称重至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_25天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_25天内称重至签收]"
                      name="_25天内称重至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_超过25天称重至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_超过25天称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_超过25天称重至签收]"
                      name="_超过25天称重至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_4天内上网至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_4天内上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_4天内上网至签收]"
                      name="_4天内上网至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_5天内上网至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_5天内上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_5天内上网至签收]"
                      name="_5天内上网至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_6天内上网至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_6天内上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_6天内上网至签收]"
                      name="_6天内上网至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_7天内上网至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_7天内上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_7天内上网至签收]"
                      name="_7天内上网至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_8天内上网至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_8天内上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_8天内上网至签收]"
                      name="_8天内上网至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_9天内上网至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_9天内上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_9天内上网至签收]"
                      name="_9天内上网至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_10天内上网至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_10天内上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_10天内上网至签收]"
                      name="_10天内上网至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_11天内上网至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_11天内上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_11天内上网至签收]"
                      name="_11天内上网至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_12天内上网至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_12天内上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_12天内上网至签收]"
                      name="_12天内上网至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_13天内上网至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_13天内上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_13天内上网至签收]"
                      name="_13天内上网至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_14天内上网至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_14天内上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_14天内上网至签收]"
                      name="_14天内上网至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_15天内上网至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_15天内上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_15天内上网至签收]"
                      name="_15天内上网至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_16天内上网至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_16天内上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_16天内上网至签收]"
                      name="_16天内上网至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_17天内上网至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_17天内上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_17天内上网至签收]"
                      name="_17天内上网至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_18天内上网至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_18天内上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_18天内上网至签收]"
                      name="_18天内上网至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_19天内上网至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_19天内上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_19天内上网至签收]"
                      name="_19天内上网至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_20天内上网至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_20天内上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_20天内上网至签收]"
                      name="_20天内上网至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_超过20天上网至签收]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_超过20天上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_超过20天上网至签收]"
                      name="_超过20天上网至签收"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[落地日期]"
                      dataType="wstr"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[落地日期]"
                      length="16"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[落地日期]"
                      name="落地日期"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[提取日期]"
                      dataType="wstr"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[提取日期]"
                      length="16"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[提取日期]"
                      name="提取日期"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[所属客户]"
                      dataType="wstr"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[所属客户]"
                      length="64"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[所属客户]"
                      name="所属客户"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[收货日期]"
                      dataType="wstr"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[收货日期]"
                      length="10"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[收货日期]"
                      name="收货日期"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[总时效]"
                      dataType="i4"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[总时效]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[总时效]"
                      name="总时效"
                      truncationRowDisposition="FailComponent" />
                  </outputColumns>
                  <externalMetadataColumns
                    isUsed="True">
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[提单号]"
                      dataType="wstr"
                      length="50"
                      name="提单号" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[实际派送渠道]"
                      dataType="wstr"
                      length="64"
                      name="实际派送渠道" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[渠道名称]"
                      dataType="wstr"
                      length="50"
                      name="渠道名称" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[末端分区]"
                      dataType="wstr"
                      length="50"
                      name="末端分区" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[州名]"
                      dataType="wstr"
                      length="255"
                      name="州名" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[出货日期]"
                      dataType="wstr"
                      length="10"
                      name="出货日期" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[起飞日期]"
                      dataType="wstr"
                      length="10"
                      name="起飞日期" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[落地日期]"
                      dataType="wstr"
                      length="16"
                      name="落地日期" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[第一票上网时间]"
                      dataType="dbTimeStamp"
                      name="第一票上网时间" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[口岸]"
                      dataType="wstr"
                      length="64"
                      name="口岸" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[代理]"
                      dataType="wstr"
                      length="64"
                      name="代理" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[上网票数]"
                      dataType="i4"
                      name="上网票数" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[签收票数]"
                      dataType="i4"
                      name="签收票数" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[出货票数]"
                      dataType="i4"
                      name="出货票数" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[收货重量]"
                      dataType="numeric"
                      name="收货重量"
                      precision="38"
                      scale="6" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_2天内上网票数]"
                      dataType="i4"
                      name="_2天内上网票数" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_3天内上网票数]"
                      dataType="i4"
                      name="_3天内上网票数" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_5天内称重至签收]"
                      dataType="i4"
                      name="_5天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_6天内称重至签收]"
                      dataType="i4"
                      name="_6天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_7天内称重至签收]"
                      dataType="i4"
                      name="_7天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_8天内称重至签收]"
                      dataType="i4"
                      name="_8天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_9天内称重至签收]"
                      dataType="i4"
                      name="_9天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_10天内称重至签收]"
                      dataType="i4"
                      name="_10天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_11天内称重至签收]"
                      dataType="i4"
                      name="_11天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_12天内称重至签收]"
                      dataType="i4"
                      name="_12天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_13天内称重至签收]"
                      dataType="i4"
                      name="_13天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_14天内称重至签收]"
                      dataType="i4"
                      name="_14天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_15天内称重至签收]"
                      dataType="i4"
                      name="_15天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_16天内称重至签收]"
                      dataType="i4"
                      name="_16天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_17天内称重至签收]"
                      dataType="i4"
                      name="_17天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_18天内称重至签收]"
                      dataType="i4"
                      name="_18天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_19天内称重至签收]"
                      dataType="i4"
                      name="_19天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_20天内称重至签收]"
                      dataType="i4"
                      name="_20天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_21天内称重至签收]"
                      dataType="i4"
                      name="_21天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_22天内称重至签收]"
                      dataType="i4"
                      name="_22天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_23天内称重至签收]"
                      dataType="i4"
                      name="_23天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_24天内称重至签收]"
                      dataType="i4"
                      name="_24天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_25天内称重至签收]"
                      dataType="i4"
                      name="_25天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_超过25天称重至签收]"
                      dataType="i4"
                      name="_超过25天称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_4天内上网至签收]"
                      dataType="i4"
                      name="_4天内上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_5天内上网至签收]"
                      dataType="i4"
                      name="_5天内上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_6天内上网至签收]"
                      dataType="i4"
                      name="_6天内上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_7天内上网至签收]"
                      dataType="i4"
                      name="_7天内上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_8天内上网至签收]"
                      dataType="i4"
                      name="_8天内上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_9天内上网至签收]"
                      dataType="i4"
                      name="_9天内上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_10天内上网至签收]"
                      dataType="i4"
                      name="_10天内上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_11天内上网至签收]"
                      dataType="i4"
                      name="_11天内上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_12天内上网至签收]"
                      dataType="i4"
                      name="_12天内上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_13天内上网至签收]"
                      dataType="i4"
                      name="_13天内上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_14天内上网至签收]"
                      dataType="i4"
                      name="_14天内上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_15天内上网至签收]"
                      dataType="i4"
                      name="_15天内上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_16天内上网至签收]"
                      dataType="i4"
                      name="_16天内上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_17天内上网至签收]"
                      dataType="i4"
                      name="_17天内上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_18天内上网至签收]"
                      dataType="i4"
                      name="_18天内上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_19天内上网至签收]"
                      dataType="i4"
                      name="_19天内上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_20天内上网至签收]"
                      dataType="i4"
                      name="_20天内上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[_超过20天上网至签收]"
                      dataType="i4"
                      name="_超过20天上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[提取日期]"
                      dataType="wstr"
                      length="16"
                      name="提取日期" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[所属客户]"
                      dataType="wstr"
                      length="64"
                      name="所属客户" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[收货日期]"
                      dataType="wstr"
                      length="10"
                      name="收货日期" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[总时效]"
                      dataType="i4"
                      name="总时效" />
                  </externalMetadataColumns>
                </output>
                <output
                  refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出]"
                  isErrorOut="true"
                  name="OLE DB 源错误输出">
                  <outputColumns>
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[提单号]"
                      dataType="wstr"
                      length="50"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[提单号]"
                      name="提单号" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[实际派送渠道]"
                      dataType="wstr"
                      length="64"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[实际派送渠道]"
                      name="实际派送渠道" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[渠道名称]"
                      dataType="wstr"
                      length="50"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[渠道名称]"
                      name="渠道名称" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[末端分区]"
                      dataType="wstr"
                      length="50"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[末端分区]"
                      name="末端分区" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[州名]"
                      dataType="wstr"
                      length="255"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[州名]"
                      name="州名" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[出货日期]"
                      dataType="wstr"
                      length="10"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[出货日期]"
                      name="出货日期" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[起飞日期]"
                      dataType="wstr"
                      length="10"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[起飞日期]"
                      name="起飞日期" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[收货日期]"
                      dataType="wstr"
                      length="10"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[收货日期]"
                      name="收货日期" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[第一票上网时间]"
                      dataType="dbTimeStamp"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[第一票上网时间]"
                      name="第一票上网时间" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[口岸]"
                      dataType="wstr"
                      length="64"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[口岸]"
                      name="口岸" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[代理]"
                      dataType="wstr"
                      length="64"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[代理]"
                      name="代理" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[上网票数]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[上网票数]"
                      name="上网票数" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[签收票数]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[签收票数]"
                      name="签收票数" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[出货票数]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[出货票数]"
                      name="出货票数" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[收货重量]"
                      dataType="numeric"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[收货重量]"
                      name="收货重量"
                      precision="38"
                      scale="6" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_2天内上网票数]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_2天内上网票数]"
                      name="_2天内上网票数" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[总时效]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[总时效]"
                      name="总时效" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_3天内上网票数]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_3天内上网票数]"
                      name="_3天内上网票数" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_5天内称重至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_5天内称重至签收]"
                      name="_5天内称重至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_6天内称重至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_6天内称重至签收]"
                      name="_6天内称重至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_7天内称重至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_7天内称重至签收]"
                      name="_7天内称重至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_8天内称重至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_8天内称重至签收]"
                      name="_8天内称重至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_9天内称重至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_9天内称重至签收]"
                      name="_9天内称重至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_10天内称重至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_10天内称重至签收]"
                      name="_10天内称重至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_11天内称重至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_11天内称重至签收]"
                      name="_11天内称重至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_12天内称重至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_12天内称重至签收]"
                      name="_12天内称重至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_13天内称重至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_13天内称重至签收]"
                      name="_13天内称重至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_14天内称重至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_14天内称重至签收]"
                      name="_14天内称重至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_15天内称重至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_15天内称重至签收]"
                      name="_15天内称重至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_16天内称重至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_16天内称重至签收]"
                      name="_16天内称重至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_17天内称重至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_17天内称重至签收]"
                      name="_17天内称重至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_18天内称重至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_18天内称重至签收]"
                      name="_18天内称重至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_19天内称重至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_19天内称重至签收]"
                      name="_19天内称重至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_20天内称重至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_20天内称重至签收]"
                      name="_20天内称重至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_21天内称重至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_21天内称重至签收]"
                      name="_21天内称重至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_22天内称重至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_22天内称重至签收]"
                      name="_22天内称重至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_23天内称重至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_23天内称重至签收]"
                      name="_23天内称重至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_24天内称重至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_24天内称重至签收]"
                      name="_24天内称重至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_25天内称重至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_25天内称重至签收]"
                      name="_25天内称重至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_超过25天称重至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_超过25天称重至签收]"
                      name="_超过25天称重至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_4天内上网至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_4天内上网至签收]"
                      name="_4天内上网至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_5天内上网至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_5天内上网至签收]"
                      name="_5天内上网至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_6天内上网至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_6天内上网至签收]"
                      name="_6天内上网至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_7天内上网至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_7天内上网至签收]"
                      name="_7天内上网至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_8天内上网至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_8天内上网至签收]"
                      name="_8天内上网至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_9天内上网至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_9天内上网至签收]"
                      name="_9天内上网至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_10天内上网至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_10天内上网至签收]"
                      name="_10天内上网至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_11天内上网至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_11天内上网至签收]"
                      name="_11天内上网至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_12天内上网至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_12天内上网至签收]"
                      name="_12天内上网至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_13天内上网至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_13天内上网至签收]"
                      name="_13天内上网至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_14天内上网至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_14天内上网至签收]"
                      name="_14天内上网至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_15天内上网至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_15天内上网至签收]"
                      name="_15天内上网至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_16天内上网至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_16天内上网至签收]"
                      name="_16天内上网至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_17天内上网至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_17天内上网至签收]"
                      name="_17天内上网至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_18天内上网至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_18天内上网至签收]"
                      name="_18天内上网至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_19天内上网至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_19天内上网至签收]"
                      name="_19天内上网至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_20天内上网至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_20天内上网至签收]"
                      name="_20天内上网至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_超过20天上网至签收]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[_超过20天上网至签收]"
                      name="_超过20天上网至签收" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[ErrorCode]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[ErrorCode]"
                      name="ErrorCode"
                      specialFlags="1" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[ErrorColumn]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[ErrorColumn]"
                      name="ErrorColumn"
                      specialFlags="2" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[落地日期]"
                      dataType="wstr"
                      length="16"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[落地日期]"
                      name="落地日期" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[提取日期]"
                      dataType="wstr"
                      length="16"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[提取日期]"
                      name="提取日期" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[所属客户]"
                      dataType="wstr"
                      length="64"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[所属客户]"
                      name="所属客户" />
                  </outputColumns>
                  <externalMetadataColumns />
                </output>
              </outputs>
            </component>
            <component
              refId="Package\数据流任务\OLE DB 目标"
              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 目标"
              usesDispositions="true"
              version="4">
              <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"></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 目标.Connections[OleDbConnection]"
                  connectionManagerID="Package.ConnectionManagers[rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy1 1]"
                  connectionManagerRefId="Package.ConnectionManagers[rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy1 1]"
                  description="指定用于访问数据库的 OLE DB 运行时连接。"
                  name="OleDbConnection" />
              </connections>
              <inputs>
                <input
                  refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入]"
                  errorOrTruncationOperation="插入"
                  errorRowDisposition="FailComponent"
                  hasSideEffects="true"
                  name="OLE DB 目标输入">
                  <inputColumns>
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[提单号]"
                      cachedDataType="wstr"
                      cachedLength="50"
                      cachedName="提单号"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[提单号]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[提单号]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[实际派送渠道]"
                      cachedDataType="wstr"
                      cachedLength="64"
                      cachedName="实际派送渠道"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[实际派送渠道]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[实际派送渠道]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[渠道名称]"
                      cachedDataType="wstr"
                      cachedLength="50"
                      cachedName="渠道名称"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[渠道名称]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[渠道名称]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[末端分区]"
                      cachedDataType="wstr"
                      cachedLength="50"
                      cachedName="末端分区"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[末端分区]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[末端分区]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[州名]"
                      cachedDataType="wstr"
                      cachedLength="128"
                      cachedName="州名"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[州名]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[州名]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[出货日期]"
                      cachedDataType="wstr"
                      cachedLength="10"
                      cachedName="出货日期"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[出货日期]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[出货日期]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[起飞日期]"
                      cachedDataType="wstr"
                      cachedLength="10"
                      cachedName="起飞日期"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[起飞日期]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[起飞日期]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[落地日期]"
                      cachedDataType="wstr"
                      cachedLength="16"
                      cachedName="落地日期"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[落地日期]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[落地日期]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[第一票上网时间]"
                      cachedDataType="dbTimeStamp"
                      cachedName="第一票上网时间"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[第一票上网时间]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[第一票上网时间]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[口岸]"
                      cachedDataType="wstr"
                      cachedLength="64"
                      cachedName="口岸"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[口岸]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[口岸]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[代理]"
                      cachedDataType="wstr"
                      cachedLength="64"
                      cachedName="代理"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[代理]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[代理]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[上网票数]"
                      cachedDataType="i4"
                      cachedName="上网票数"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[上网票数]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[上网票数]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[签收票数]"
                      cachedDataType="i4"
                      cachedName="签收票数"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[签收票数]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[签收票数]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[出货票数]"
                      cachedDataType="i4"
                      cachedName="出货票数"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[出货票数]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[出货票数]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[收货重量]"
                      cachedDataType="numeric"
                      cachedName="收货重量"
                      cachedPrecision="38"
                      cachedScale="6"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[收货重量]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[收货重量]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_2天内上网票数]"
                      cachedDataType="i4"
                      cachedName="_2天内上网票数"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_2天内上网票数]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_2天内上网票数]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_3天内上网票数]"
                      cachedDataType="i4"
                      cachedName="_3天内上网票数"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_3天内上网票数]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_3天内上网票数]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_5天内称重至签收]"
                      cachedDataType="i4"
                      cachedName="_5天内称重至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_5天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_5天内称重至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_6天内称重至签收]"
                      cachedDataType="i4"
                      cachedName="_6天内称重至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_6天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_6天内称重至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_7天内称重至签收]"
                      cachedDataType="i4"
                      cachedName="_7天内称重至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_7天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_7天内称重至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_8天内称重至签收]"
                      cachedDataType="i4"
                      cachedName="_8天内称重至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_8天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_8天内称重至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_9天内称重至签收]"
                      cachedDataType="i4"
                      cachedName="_9天内称重至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_9天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_9天内称重至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_10天内称重至签收]"
                      cachedDataType="i4"
                      cachedName="_10天内称重至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_10天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_10天内称重至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_11天内称重至签收]"
                      cachedDataType="i4"
                      cachedName="_11天内称重至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_11天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_11天内称重至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_12天内称重至签收]"
                      cachedDataType="i4"
                      cachedName="_12天内称重至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_12天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_12天内称重至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_13天内称重至签收]"
                      cachedDataType="i4"
                      cachedName="_13天内称重至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_13天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_13天内称重至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_14天内称重至签收]"
                      cachedDataType="i4"
                      cachedName="_14天内称重至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_14天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_14天内称重至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_15天内称重至签收]"
                      cachedDataType="i4"
                      cachedName="_15天内称重至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_15天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_15天内称重至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_16天内称重至签收]"
                      cachedDataType="i4"
                      cachedName="_16天内称重至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_16天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_16天内称重至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_17天内称重至签收]"
                      cachedDataType="i4"
                      cachedName="_17天内称重至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_17天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_17天内称重至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_18天内称重至签收]"
                      cachedDataType="i4"
                      cachedName="_18天内称重至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_18天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_18天内称重至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_19天内称重至签收]"
                      cachedDataType="i4"
                      cachedName="_19天内称重至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_19天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_19天内称重至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_20天内称重至签收]"
                      cachedDataType="i4"
                      cachedName="_20天内称重至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_20天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_20天内称重至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_21天内称重至签收]"
                      cachedDataType="i4"
                      cachedName="_21天内称重至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_21天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_21天内称重至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_22天内称重至签收]"
                      cachedDataType="i4"
                      cachedName="_22天内称重至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_22天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_22天内称重至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_23天内称重至签收]"
                      cachedDataType="i4"
                      cachedName="_23天内称重至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_23天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_23天内称重至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_24天内称重至签收]"
                      cachedDataType="i4"
                      cachedName="_24天内称重至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_24天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_24天内称重至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_25天内称重至签收]"
                      cachedDataType="i4"
                      cachedName="_25天内称重至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_25天内称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_25天内称重至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_超过25天称重至签收]"
                      cachedDataType="i4"
                      cachedName="_超过25天称重至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_超过25天称重至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_超过25天称重至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_4天内上网至签收]"
                      cachedDataType="i4"
                      cachedName="_4天内上网至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_4天内上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_4天内上网至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_5天内上网至签收]"
                      cachedDataType="i4"
                      cachedName="_5天内上网至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_5天内上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_5天内上网至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_6天内上网至签收]"
                      cachedDataType="i4"
                      cachedName="_6天内上网至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_6天内上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_6天内上网至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_7天内上网至签收]"
                      cachedDataType="i4"
                      cachedName="_7天内上网至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_7天内上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_7天内上网至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_8天内上网至签收]"
                      cachedDataType="i4"
                      cachedName="_8天内上网至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_8天内上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_8天内上网至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_9天内上网至签收]"
                      cachedDataType="i4"
                      cachedName="_9天内上网至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_9天内上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_9天内上网至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_10天内上网至签收]"
                      cachedDataType="i4"
                      cachedName="_10天内上网至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_10天内上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_10天内上网至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_11天内上网至签收]"
                      cachedDataType="i4"
                      cachedName="_11天内上网至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_11天内上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_11天内上网至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_12天内上网至签收]"
                      cachedDataType="i4"
                      cachedName="_12天内上网至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_12天内上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_12天内上网至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_13天内上网至签收]"
                      cachedDataType="i4"
                      cachedName="_13天内上网至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_13天内上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_13天内上网至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_14天内上网至签收]"
                      cachedDataType="i4"
                      cachedName="_14天内上网至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_14天内上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_14天内上网至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_15天内上网至签收]"
                      cachedDataType="i4"
                      cachedName="_15天内上网至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_15天内上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_15天内上网至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_16天内上网至签收]"
                      cachedDataType="i4"
                      cachedName="_16天内上网至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_16天内上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_16天内上网至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_17天内上网至签收]"
                      cachedDataType="i4"
                      cachedName="_17天内上网至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_17天内上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_17天内上网至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_18天内上网至签收]"
                      cachedDataType="i4"
                      cachedName="_18天内上网至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_18天内上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_18天内上网至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_19天内上网至签收]"
                      cachedDataType="i4"
                      cachedName="_19天内上网至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_19天内上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_19天内上网至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_20天内上网至签收]"
                      cachedDataType="i4"
                      cachedName="_20天内上网至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_20天内上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_20天内上网至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[_超过20天上网至签收]"
                      cachedDataType="i4"
                      cachedName="_超过20天上网至签收"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_超过20天上网至签收]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[_超过20天上网至签收]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[提取日期]"
                      cachedDataType="wstr"
                      cachedLength="16"
                      cachedName="提取日期"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[提取日期]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[提取日期]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[所属客户]"
                      cachedDataType="wstr"
                      cachedLength="64"
                      cachedName="所属客户"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[所属客户]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[所属客户]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[收货日期]"
                      cachedDataType="wstr"
                      cachedLength="10"
                      cachedName="收货日期"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[收货日期]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[收货日期]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[总时效]"
                      cachedDataType="i4"
                      cachedName="总时效"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[总时效]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[总时效]" />
                  </inputColumns>
                  <externalMetadataColumns
                    isUsed="True">
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[提单号]"
                      dataType="wstr"
                      length="50"
                      name="提单号" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[实际派送渠道]"
                      dataType="wstr"
                      length="64"
                      name="实际派送渠道" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[渠道名称]"
                      dataType="wstr"
                      length="50"
                      name="渠道名称" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[末端分区]"
                      dataType="wstr"
                      length="50"
                      name="末端分区" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[州名]"
                      dataType="wstr"
                      length="128"
                      name="州名" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[出货日期]"
                      dataType="wstr"
                      length="10"
                      name="出货日期" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[起飞日期]"
                      dataType="wstr"
                      length="10"
                      name="起飞日期" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[落地日期]"
                      dataType="wstr"
                      length="16"
                      name="落地日期" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[第一票上网时间]"
                      dataType="dbTimeStamp"
                      name="第一票上网时间" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[口岸]"
                      dataType="wstr"
                      length="64"
                      name="口岸" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[代理]"
                      dataType="wstr"
                      length="64"
                      name="代理" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[上网票数]"
                      dataType="i4"
                      name="上网票数" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[签收票数]"
                      dataType="i4"
                      name="签收票数" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[出货票数]"
                      dataType="i4"
                      name="出货票数" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[收货重量]"
                      dataType="numeric"
                      name="收货重量"
                      precision="38"
                      scale="6" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_2天内上网票数]"
                      dataType="i4"
                      name="_2天内上网票数" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_3天内上网票数]"
                      dataType="i4"
                      name="_3天内上网票数" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_5天内称重至签收]"
                      dataType="i4"
                      name="_5天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_6天内称重至签收]"
                      dataType="i4"
                      name="_6天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_7天内称重至签收]"
                      dataType="i4"
                      name="_7天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_8天内称重至签收]"
                      dataType="i4"
                      name="_8天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_9天内称重至签收]"
                      dataType="i4"
                      name="_9天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_10天内称重至签收]"
                      dataType="i4"
                      name="_10天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_11天内称重至签收]"
                      dataType="i4"
                      name="_11天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_12天内称重至签收]"
                      dataType="i4"
                      name="_12天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_13天内称重至签收]"
                      dataType="i4"
                      name="_13天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_14天内称重至签收]"
                      dataType="i4"
                      name="_14天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_15天内称重至签收]"
                      dataType="i4"
                      name="_15天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_16天内称重至签收]"
                      dataType="i4"
                      name="_16天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_17天内称重至签收]"
                      dataType="i4"
                      name="_17天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_18天内称重至签收]"
                      dataType="i4"
                      name="_18天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_19天内称重至签收]"
                      dataType="i4"
                      name="_19天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_20天内称重至签收]"
                      dataType="i4"
                      name="_20天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_21天内称重至签收]"
                      dataType="i4"
                      name="_21天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_22天内称重至签收]"
                      dataType="i4"
                      name="_22天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_23天内称重至签收]"
                      dataType="i4"
                      name="_23天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_24天内称重至签收]"
                      dataType="i4"
                      name="_24天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_25天内称重至签收]"
                      dataType="i4"
                      name="_25天内称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_超过25天称重至签收]"
                      dataType="i4"
                      name="_超过25天称重至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_4天内上网至签收]"
                      dataType="i4"
                      name="_4天内上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_5天内上网至签收]"
                      dataType="i4"
                      name="_5天内上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_6天内上网至签收]"
                      dataType="i4"
                      name="_6天内上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_7天内上网至签收]"
                      dataType="i4"
                      name="_7天内上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_8天内上网至签收]"
                      dataType="i4"
                      name="_8天内上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_9天内上网至签收]"
                      dataType="i4"
                      name="_9天内上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_10天内上网至签收]"
                      dataType="i4"
                      name="_10天内上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_11天内上网至签收]"
                      dataType="i4"
                      name="_11天内上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_12天内上网至签收]"
                      dataType="i4"
                      name="_12天内上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_13天内上网至签收]"
                      dataType="i4"
                      name="_13天内上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_14天内上网至签收]"
                      dataType="i4"
                      name="_14天内上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_15天内上网至签收]"
                      dataType="i4"
                      name="_15天内上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_16天内上网至签收]"
                      dataType="i4"
                      name="_16天内上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_17天内上网至签收]"
                      dataType="i4"
                      name="_17天内上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_18天内上网至签收]"
                      dataType="i4"
                      name="_18天内上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_19天内上网至签收]"
                      dataType="i4"
                      name="_19天内上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_20天内上网至签收]"
                      dataType="i4"
                      name="_20天内上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[_超过20天上网至签收]"
                      dataType="i4"
                      name="_超过20天上网至签收" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[提取日期]"
                      dataType="wstr"
                      length="16"
                      name="提取日期" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[所属客户]"
                      dataType="wstr"
                      length="64"
                      name="所属客户" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[收货日期]"
                      dataType="wstr"
                      length="10"
                      name="收货日期" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[总时效]"
                      dataType="i4"
                      name="总时效" />
                  </externalMetadataColumns>
                </input>
              </inputs>
              <outputs>
                <output
                  refId="Package\数据流任务\OLE DB 目标.Outputs[OLE DB 目标错误输出]"
                  exclusionGroup="1"
                  isErrorOut="true"
                  name="OLE DB 目标错误输出"
                  synchronousInputId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入]">
                  <outputColumns>
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 目标.Outputs[OLE DB 目标错误输出].Columns[ErrorCode]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 目标.Outputs[OLE DB 目标错误输出].Columns[ErrorCode]"
                      name="ErrorCode"
                      specialFlags="1" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 目标.Outputs[OLE DB 目标错误输出].Columns[ErrorColumn]"
                      dataType="i4"
                      lineageId="Package\数据流任务\OLE DB 目标.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 目标.Inputs[OLE DB 目标输入]"
              name="OLE DB 源输出"
              startId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出]" />
          </paths>
        </pipeline>
      </DTS:ObjectData>
    </DTS:Executable>
  </DTS:Executables>
  <DTS:PrecedenceConstraints>
    <DTS:PrecedenceConstraint
      DTS:refId="Package.PrecedenceConstraints[Constraint]"
      DTS:CreationName=""
      DTS:DTSID="{8E855359-F065-4708-9D32-8CF7852DEAE5}"
      DTS:From="Package\执行 SQL 任务"
      DTS:LogicalAnd="True"
      DTS:ObjectName="Constraint"
      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="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="138.4,41.6"
          Id="Package\数据流任务"
          TopLeft="156.666660441292,176.42856241489" />
        <NodeLayout
          Size="156.8,41.6"
          Id="Package\执行 SQL 任务"
          TopLeft="163.33332684305,21.357141766013" />
        <EdgeLayout
          Id="Package.PrecedenceConstraints[Constraint]"
          TopLeft="241.73332684305,62.957141766013">
          <EdgeLayout.Curve>
            <mssgle:Curve
              StartConnector="{assembly:Null}"
              EndConnector="-15.866666401758,113.471420648877"
              Start="0,0"
              End="-15.866666401758,105.971420648877">
              <mssgle:Curve.Segments>
                <mssgle:SegmentCollection
                  Capacity="5">
                  <mssgle:LineSegment
                    End="0,52.7357103244385" />
                  <mssgle:CubicBezierSegment
                    Point1="0,52.7357103244385"
                    Point2="0,56.7357103244385"
                    Point3="-4,56.7357103244385" />
                  <mssgle:LineSegment
                    End="-11.866666401758,56.7357103244385" />
                  <mssgle:CubicBezierSegment
                    Point1="-11.866666401758,56.7357103244385"
                    Point2="-15.866666401758,56.7357103244385"
                    Point3="-15.866666401758,60.7357103244385" />
                  <mssgle:LineSegment
                    End="-15.866666401758,105.971420648877" />
                </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="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="132,41.6"
          Id="Package\数据流任务\OLE DB 源"
          TopLeft="183.333326048321,145.785706837567" />
        <NodeLayout
          Size="144.8,41.6"
          Id="Package\数据流任务\OLE DB 目标"
          TopLeft="209.16665835513,282.285699863824" />
        <EdgeLayout
          Id="Package\数据流任务.Paths[OLE DB 源输出]"
          TopLeft="249.333326048321,187.385706837567">
          <EdgeLayout.Curve>
            <mssgle:Curve
              StartConnector="{assembly:Null}"
              EndConnector="32.233332306809,94.899993026257"
              Start="0,0"
              End="32.233332306809,87.399993026257">
              <mssgle:Curve.Segments>
                <mssgle:SegmentCollection
                  Capacity="5">
                  <mssgle:LineSegment
                    End="0,43.4499965131285" />
                  <mssgle:CubicBezierSegment
                    Point1="0,43.4499965131285"
                    Point2="0,47.4499965131285"
                    Point3="4,47.4499965131285" />
                  <mssgle:LineSegment
                    End="28.233332306809,47.4499965131285" />
                  <mssgle:CubicBezierSegment
                    Point1="28.233332306809,47.4499965131285"
                    Point2="32.233332306809,47.4499965131285"
                    Point3="32.233332306809,51.4499965131285" />
                  <mssgle:LineSegment
                    End="32.233332306809,87.399993026257" />
                </mssgle:SegmentCollection>
              </mssgle:Curve.Segments>
            </mssgle:Curve>
          </EdgeLayout.Curve>
          <EdgeLayout.Labels>
            <EdgeLabelCollection />
          </EdgeLayout.Labels>
        </EdgeLayout>
      </GraphLayout>
    </LayoutInfo>
  </TaskHost>
  <PipelineComponentMetadata
    design-time-name="Package\数据流任务\OLE DB 源">
    <Properties>
      <Property>
        <Name>DataSourceViewID</Name>
      </Property>
    </Properties>
  </PipelineComponentMetadata>
  <PipelineComponentMetadata
    design-time-name="Package\数据流任务\OLE DB 目标">
    <Properties>
      <Property>
        <Name>DataSourceViewID</Name>
      </Property>
      <Property>
        <Name>TableInfoObjectType</Name>
        <Value
          type="q2:string">Table</Value>
      </Property>
    </Properties>
  </PipelineComponentMetadata>
</Objects>]]></DTS:DesignTimeProperties>
</DTS:Executable>