XYY.BI.ELT/空派物流信息.dtsx

<?xml version="1.0"?>
<DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts"
  DTS:refId="Package"
  DTS:CreationDate="9/14/2022 5:22:46 PM"
  DTS:CreationName="Microsoft.Package"
  DTS:CreatorComputerName="LZKPC20200625"
  DTS:CreatorName="LZKPC20200625\lzk"
  DTS:DTSID="{6281041E-6A80-4B8D-BF13-5B6C58813F4B}"
  DTS:ExecutableType="Microsoft.Package"
  DTS:LastModifiedProductVersion="16.0.694.0"
  DTS:LocaleID="2052"
  DTS:ObjectName="Package1"
  DTS:PackageType="5"
  DTS:VersionBuild="1"
  DTS:VersionGUID="{003EC9F8-899B-44EC-B9B6-3C880F77C2EB}">
  <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.xyy]"
      DTS:CreationName="OLEDB"
      DTS:DTSID="{422A441D-8826-42B5-B68A-51CB48B1FF8A}"
      DTS:ObjectName="rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy">
      <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;Application Name=SSIS-Package1-{422A441D-8826-42B5-B68A-51CB48B1FF8A}rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy;Auto Translate=False;">
          <DTS:Password
            DTS:Name="Password"
            Sensitive="1"
            Encrypted="1">AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAo9GuKPMDY0aemO4cp96DtgAAAAAIAAAARABUAFMAAAAQZgAAAAEAACAAAAC4keOmMUDdIrIRNY9m2ute85n3rFYRd5Lu5NBOdL/jVAAAAAAOgAAAAAIAACAAAAB6H0zQYGgp60j0/goGtxDrBjOCb4Vtyfil1qd8oJXB0TAAAACL1AX5ECz/gtNrz12rLEvQbQCdK/dp+kqv4HH2krjPRBK0bzLqxaEcxB5O+gmrcPZAAAAApdMoOb5LpnbiSKusIIvVGVat2DenZZwjM7OV4lV80Y8P2kYYUsZVN3fD//WXLMgbBoQod1ncgL4iQw3O4SUxFg</DTS:Password>
        </DTS:ConnectionManager>
      </DTS:ObjectData>
    </DTS:ConnectionManager>
    <DTS:ConnectionManager
      DTS:refId="Package.ConnectionManagers[rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy 1]"
      DTS:CreationName="OLEDB"
      DTS:DTSID="{0F0C44DE-E6E9-4A94-BB06-4FE4B9F6DAC5}"
      DTS:ObjectName="rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy 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;Application Name=SSIS-Package1-{0F0C44DE-E6E9-4A94-BB06-4FE4B9F6DAC5}rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy 1;Auto Translate=False;">
          <DTS:Password
            DTS:Name="Password"
            Sensitive="1"
            Encrypted="1">AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAo9GuKPMDY0aemO4cp96DtgAAAAAIAAAARABUAFMAAAAQZgAAAAEAACAAAABhm/BoinjaUc32mIEcV/zA2Vm/CSve4tILOY3CeSHtfAAAAAAOgAAAAAIAACAAAAAXoUlZFQ3vOSuvXuhfctJcclSo3AlARCC75NPR1NyANDAAAABajOjIyBlemoS6Uw2edMeYfhApF4rkKo9jSg03Lz84PwliaeBxGNNQ/rydTysSOpNAAAAApF1os1yCI0ARzb/wG5b8WhODjnyGfxhITgUQ4FQaS6SAKuDiBq3x4whSf6EEZtLMHCbRvoeabApk2ps4hfaCvQ</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="{CBB3A74A-6628-419A-8FE4-ADA96528ECE0}"
      DTS:ExecutableType="Microsoft.ExecuteSQLTask"
      DTS:LocaleID="-1"
      DTS:ObjectName="执行 SQL 任务"
      DTS:ThreadHint="0">
      <DTS:Variables />
      <DTS:ObjectData>
        <SQLTask:SqlTaskData
          SQLTask:Connection="{422A441D-8826-42B5-B68A-51CB48B1FF8A}"
          SQLTask:SqlStatementSource="truncate table BaseETL_FBATraceInfo" 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="{EC35F228-0793-4D93-8024-8D8F18B79144}"
      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">[dbo].[BaseETL_FBATraceInfo]</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">select b.CustomerOrderNo [客户单号],b.TrackingNumber [服务商单号],b.SystemNo [系统单号],b.ReceiverCountryCode[国家/地区],b.CreateTime [下单时间],b.ReceiveTime[称重时间],b.SendOutTime[出货时间],b.CustomerWeight[下单重]
,b.OPWeight[实重],
d.BillingWeight*1000 [计费重],
c.Status[最新物流状态],c.LastMessage[最新物流信息],c.TargetTime[最新物流时间],DATEDIFF(HOUR,b.SendOutTime,GETDATE())/24.0 [发货天数],c.OnlineTime[上网时间],DATEDIFF(HOUR,b.SendOutTime,c.OnlineTime)/24.0 [上网天数],c.SignTime[签收时间],DATEDIFF(HOUR,b.SendOutTime,c.SignTime)/24.0 [签收天数],
a.LadingBillNumber[提单号],
e.PublicName[产品名称],e1.PublicName[渠道名称],
f.MpsBoxNum [箱数],0.00[预计费用],'' [含IOSS]
from (select distinct CustomerOrderNumber,LadingBillNumber from Order_MpsOrder(nolock)) a
left join Order_Order(nolock) b on b.CustomerOrderNo=a.CustomerOrderNumber and b.MpsOrderId&gt;0
left join Logistics_Trace(nolock) c on c.OrderId=b.Id
left join Finance_ChargesDetail(nolock) d on d.BillNo=b.SystemNo and d.BillType='全程派送运费' and d.Offset=0 and d.CustomerId=b.CustomerId
left join Logistics_Channel(nolock) e on e.Id=b.CreateOrderChannelId
left join Logistics_Channel(nolock) e1 on e1.Id=b.ChannelId
left join (select COUNT(Id) MpsBoxNum,MpsOrderId from Order_MpsOrderBox group by MpsOrderId) f on f.MpsOrderId=b.MpsOrderId
where ''!=ISNULL(b.CustomerOrderNo,'')</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.xyy 1]"
                  connectionManagerRefId="Package.ConnectionManagers[rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy 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="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="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="2"
                      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="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="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="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="18"
                      scale="3"
                      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="1024"
                      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="numeric"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[发货天数]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[发货天数]"
                      name="发货天数"
                      precision="18"
                      scale="1"
                      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="numeric"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[上网天数]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[上网天数]"
                      name="上网天数"
                      precision="18"
                      scale="1"
                      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="numeric"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[签收天数]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[签收天数]"
                      name="签收天数"
                      precision="18"
                      scale="1"
                      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="500"
                      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="numeric"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[预计费用]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[预计费用]"
                      name="预计费用"
                      precision="2"
                      scale="2"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[含IOSS]"
                      codePage="936"
                      dataType="str"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[含IOSS]"
                      length="1"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[含IOSS]"
                      name="含IOSS"
                      truncationRowDisposition="FailComponent" />
                  </outputColumns>
                  <externalMetadataColumns
                    isUsed="True">
                    <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="wstr"
                      length="64"
                      name="系统单号" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[国家/地区]"
                      dataType="wstr"
                      length="2"
                      name="国家/地区" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[下单时间]"
                      dataType="dbTimeStamp"
                      name="下单时间" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[称重时间]"
                      dataType="dbTimeStamp"
                      name="称重时间" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[出货时间]"
                      dataType="dbTimeStamp"
                      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="23"
                      scale="3" />
                    <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="1024"
                      name="最新物流信息" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[最新物流时间]"
                      dataType="dbTimeStamp"
                      name="最新物流时间" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[发货天数]"
                      dataType="numeric"
                      name="发货天数"
                      precision="17"
                      scale="6" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[上网时间]"
                      dataType="dbTimeStamp"
                      name="上网时间" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[上网天数]"
                      dataType="numeric"
                      name="上网天数"
                      precision="17"
                      scale="6" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[签收时间]"
                      dataType="dbTimeStamp"
                      name="签收时间" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[签收天数]"
                      dataType="numeric"
                      name="签收天数"
                      precision="17"
                      scale="6" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[提单号]"
                      dataType="wstr"
                      length="500"
                      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="numeric"
                      name="预计费用"
                      precision="2"
                      scale="2" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[含IOSS]"
                      codePage="936"
                      dataType="str"
                      length="1"
                      name="含IOSS" />
                  </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="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="wstr"
                      length="64"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[系统单号]"
                      name="系统单号" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[国家/地区]"
                      dataType="wstr"
                      length="2"
                      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="dbTimeStamp"
                      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="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="23"
                      scale="3" />
                    <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="1024"
                      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="numeric"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[发货天数]"
                      name="发货天数"
                      precision="17"
                      scale="6" />
                    <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="numeric"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[上网天数]"
                      name="上网天数"
                      precision="17"
                      scale="6" />
                    <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="numeric"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[签收天数]"
                      name="签收天数"
                      precision="17"
                      scale="6" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[提单号]"
                      dataType="wstr"
                      length="500"
                      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="numeric"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[预计费用]"
                      name="预计费用"
                      precision="2"
                      scale="2" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[含IOSS]"
                      codePage="936"
                      dataType="str"
                      length="1"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[含IOSS]"
                      name="含IOSS" />
                    <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>
            <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">[dbo].[BaseETL_FBATraceInfo]</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.xyy]"
                  connectionManagerRefId="Package.ConnectionManagers[rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy]"
                  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="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="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="2"
                      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="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="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="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="18"
                      cachedScale="3"
                      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="1024"
                      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="numeric"
                      cachedName="发货天数"
                      cachedPrecision="18"
                      cachedScale="1"
                      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="numeric"
                      cachedName="上网天数"
                      cachedPrecision="18"
                      cachedScale="1"
                      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="numeric"
                      cachedName="签收天数"
                      cachedPrecision="18"
                      cachedScale="1"
                      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="500"
                      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="numeric"
                      cachedName="预计费用"
                      cachedPrecision="2"
                      cachedScale="2"
                      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[含IOSS]"
                      cachedCodepage="936"
                      cachedDataType="str"
                      cachedLength="1"
                      cachedName="含IOSS"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[含IOSS]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[含IOSS]" />
                  </inputColumns>
                  <externalMetadataColumns
                    isUsed="True">
                    <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="wstr"
                      length="64"
                      name="系统单号" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[国家/地区]"
                      dataType="wstr"
                      length="2"
                      name="国家/地区" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[下单时间]"
                      dataType="dbTimeStamp"
                      name="下单时间" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[称重时间]"
                      dataType="dbTimeStamp"
                      name="称重时间" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[出货时间]"
                      dataType="dbTimeStamp"
                      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="18"
                      scale="3" />
                    <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="1024"
                      name="最新物流信息" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[最新物流时间]"
                      dataType="dbTimeStamp"
                      name="最新物流时间" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[发货天数]"
                      dataType="numeric"
                      name="发货天数"
                      precision="18"
                      scale="1" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[上网时间]"
                      dataType="dbTimeStamp"
                      name="上网时间" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[上网天数]"
                      dataType="numeric"
                      name="上网天数"
                      precision="18"
                      scale="1" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[签收时间]"
                      dataType="dbTimeStamp"
                      name="签收时间" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[签收天数]"
                      dataType="numeric"
                      name="签收天数"
                      precision="18"
                      scale="1" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[提单号]"
                      dataType="wstr"
                      length="500"
                      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="numeric"
                      name="预计费用"
                      precision="2"
                      scale="2" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[含IOSS]"
                      codePage="936"
                      dataType="str"
                      length="1"
                      name="含IOSS" />
                  </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="{7AD5FF41-99E9-4DA3-AA16-A20EDC471E8D}"
      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="156,41.6"
          Id="Package\执行 SQL 任务"
          TopLeft="333.624995110556,126.111107916008" />
        <NodeLayout
          Size="138.4,41.6"
          Id="Package\数据流任务"
          TopLeft="334.249995548278,223.277772803366" />
        <EdgeLayout
          Id="Package.PrecedenceConstraints[Constraint]"
          TopLeft="411.624995110556,167.711107916008">
          <EdgeLayout.Curve>
            <mssgle:Curve
              StartConnector="{assembly:Null}"
              EndConnector="-8.1749995622784,55.5666648873577"
              Start="0,0"
              End="-8.1749995622784,48.0666648873577">
              <mssgle:Curve.Segments>
                <mssgle:SegmentCollection
                  Capacity="5">
                  <mssgle:LineSegment
                    End="0,23.7833324436789" />
                  <mssgle:CubicBezierSegment
                    Point1="0,23.7833324436789"
                    Point2="0,27.7833324436789"
                    Point3="-4,27.7833324436789" />
                  <mssgle:LineSegment
                    End="-4.1749995622784,27.7833324436789" />
                  <mssgle:CubicBezierSegment
                    Point1="-4.1749995622784,27.7833324436789"
                    Point2="-8.1749995622784,27.7833324436789"
                    Point3="-8.1749995622784,31.7833324436789" />
                  <mssgle:LineSegment
                    End="-8.1749995622784,48.0666648873577" />
                </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="319.249995324761,123.222219103648" />
        <NodeLayout
          Size="144.8,41.6"
          Id="Package\数据流任务\OLE DB 目标"
          TopLeft="300.499996051192,249.999994317691" />
        <EdgeLayout
          Id="Package\数据流任务.Paths[OLE DB 源输出]"
          TopLeft="385.249995324761,164.822219103648">
          <EdgeLayout.Curve>
            <mssgle:Curve
              StartConnector="{assembly:Null}"
              EndConnector="-12.3499992735684,85.1777752140422"
              Start="0,0"
              End="-12.3499992735684,77.6777752140422">
              <mssgle:Curve.Segments>
                <mssgle:SegmentCollection
                  Capacity="5">
                  <mssgle:LineSegment
                    End="0,38.5888876070211" />
                  <mssgle:CubicBezierSegment
                    Point1="0,38.5888876070211"
                    Point2="0,42.5888876070211"
                    Point3="-4,42.5888876070211" />
                  <mssgle:LineSegment
                    End="-8.34999927356841,42.5888876070211" />
                  <mssgle:CubicBezierSegment
                    Point1="-8.34999927356841,42.5888876070211"
                    Point2="-12.3499992735684,42.5888876070211"
                    Point3="-12.3499992735684,46.5888876070211" />
                  <mssgle:LineSegment
                    End="-12.3499992735684,77.6777752140422" />
                </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>
      <Property>
        <Name>TableInfoObjectType</Name>
        <Value
          type="q2:string">Table</Value>
      </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>