XYY.BI.ELT/运费.dtsx

<?xml version="1.0"?>
<DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts"
  DTS:refId="Package"
  DTS:CreationDate="8/1/2022 4:49:35 PM"
  DTS:CreationName="Microsoft.Package"
  DTS:CreatorComputerName="FAN"
  DTS:CreatorName="FAN\dell"
  DTS:DTSID="{E4B024DA-E55A-4A4D-91C9-88F9DB627B24}"
  DTS:ExecutableType="Microsoft.Package"
  DTS:LastModifiedProductVersion="16.0.694.0"
  DTS:LocaleID="2052"
  DTS:ObjectName="Package1"
  DTS:PackageType="5"
  DTS:VersionBuild="57"
  DTS:VersionGUID="{93AD1562-59C8-45C6-9657-C55A84C0BA1C}">
  <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="{BE56446B-F3AB-46FB-91B6-52E949E482C1}"
      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;Application Name=SSIS-Package1-{BE56446B-F3AB-46FB-91B6-52E949E482C1}rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy;Auto Translate=False;">
          <DTS:Password
            DTS:Name="Password"
            Sensitive="1"
            Encrypted="1">AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAo9GuKPMDY0aemO4cp96DtgAAAAAIAAAARABUAFMAAAAQZgAAAAEAACAAAACWsFAvy7Ru5cBmIP8MdIwbk7kyLj/tRBQQcYO/olFXmQAAAAAOgAAAAAIAACAAAABw5sjuCIuWqSQa3IbC0eMYqzPYQ0jBDgj6PcTcdf3GuzAAAAAxctj7NvRswxI2FqdAVyHKbb7b2z+iI2TBKanSA7vnmYVQUksSxKwJ1Tyj+zy7xzFAAAAA1hFdtbmKkoEco8dvFtCdGdxYpCUxGZuxPAjeceBcc0csbU+5mL9jBhB9e0QI9jJ5ZU58bLFKMnxxRD8s0LDPrw</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="{0E96A154-52C8-4F6E-A664-EF48BAC996B1}"
      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-{0E96A154-52C8-4F6E-A664-EF48BAC996B1}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+sBAAAAo9GuKPMDY0aemO4cp96DtgAAAAAIAAAARABUAFMAAAAQZgAAAAEAACAAAACkvLYGDQmgyiVFIhFUT2g4xDIQ/UrMovUI45Lp9hvjFwAAAAAOgAAAAAIAACAAAACW++6Ayl/64i8p+HeIhCSQjSLImVoDwHVliHKCMS7xiTAAAAD4ZvN6df2eujsflm3dNwOqJv8mPcPrgM/kGqfWiIc8ph+6cYhDaToOiwThB4Ggs1dAAAAAMHgyQKRDfqoYSi/KyjWA1G9/qPUOif3N2b1fXV7D77nP3p9QwlsGqzbq2fjv51EDuuYO+5hsBsGypwhSt8gmmg</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:DTSID="{00510E6A-0018-4D17-B690-96797CE3C7E1}"
      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-{00510E6A-0018-4D17-B690-96797CE3C7E1}rm-wz96o72qd45w3d6mvyo.sqlserver.rds.aliyuncs.com,3433.xyy_wms.xyy1 1;" />
      </DTS:ObjectData>
    </DTS:ConnectionManager>
  </DTS:ConnectionManagers>
  <DTS:Variables>
    <DTS:Variable
      DTS:CreationName=""
      DTS:DTSID="{AFB8E866-2C0E-4E81-8A24-72DFF2845C1B}"
      DTS:IncludeInDebugDump="6789"
      DTS:Namespace="User"
      DTS:ObjectName="LASTTIME">
      <DTS:VariableValue
        DTS:DataType="7">1/1/2022</DTS:VariableValue>
    </DTS:Variable>
  </DTS:Variables>
  <DTS:Executables>
    <DTS:Executable
      DTS:refId="Package\执行 SQL 任务"
      DTS:CreationName="Microsoft.ExecuteSQLTask"
      DTS:Description="执行 SQL 任务"
      DTS:DTSID="{213F11AA-AD61-4A0C-B4E7-F38684D8BE07}"
      DTS:ExecutableType="Microsoft.ExecuteSQLTask"
      DTS:LocaleID="-1"
      DTS:ObjectName="执行 SQL 任务"
      DTS:ThreadHint="0">
      <DTS:Variables />
      <DTS:ObjectData>
        <SQLTask:SqlTaskData
          SQLTask:Connection="{00510E6A-0018-4D17-B690-96797CE3C7E1}"
          SQLTask:SqlStatementSource="Truncate table BaseETLGroup" 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="{1A2247D2-13C1-4365-84C2-28D5996EC5E2}"
      DTS:ExecutableType="Microsoft.Pipeline"
      DTS:LocaleID="-1"
      DTS:ObjectName="数据流任务">
      <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">SET DATEFIRST 1
select fb.产品类型,fb.渠道名称,fb.实际派送渠道,fb.所属客户,fb.业务员,fb.分公司名称,
CONVERT(nvarchar(10),称重时间, 120) as Weight_Time,
CONVERT(nvarchar(10),称重时间, 120) as 称重时间,
  max(convert(varchar(7),称重时间,120) + '第'+  cast((datepart(wk,称重时间) - datepart(wk,convert(varchar(7),称重时间,120) + '-01') + 1) as varchar(2)) + '周')周,
sum(isnull(fb.称重重量,0)/1000.0) as 称重,
count(0) as 票数,
sum(isnull(bc.Profit,0)) as 毛利,
sum(isnull(mc.ShippingFee,0)+isnull(mc.EUTariff,0)+isnull(mc.AttachFee,0))收入,
sum(isnull(bc.ShippingFee,0)+isnull(bc.EUTariff,0)+isnull(bc.AttachFee,0))成本,
case  when sum(isnull(mc.ShippingFee,0)+isnull(mc.EUTariff,0)+isnull(mc.AttachFee,0))=0 
then 0 else sum(isnull(bc.Profit,0))/ sum(isnull(mc.ShippingFee,0)+isnull(mc.EUTariff,0)+isnull(mc.AttachFee,0))end 毛利占比    

,sum(isnull(smpAmount.fee,0))实际成本
,case  when sum(isnull(mc.ShippingFee,0)+isnull(mc.EUTariff,0)+isnull(mc.AttachFee,0))=0 or sum(isnull(smpAmount.fee,0))=0 then 0 
else sum(isnull(mc.ShippingFee,0)+isnull(mc.EUTariff,0)+isnull(mc.AttachFee,0))-sum(isnull(smpAmount.fee,0)) end 实际毛利
,case when sum(isnull(mc.ShippingFee,0)+isnull(mc.EUTariff,0)+isnull(mc.AttachFee,0))=0 or sum(isnull(smpAmount.fee,0))=0 then 0 else (sum(isnull(mc.ShippingFee,0)+isnull(mc.EUTariff,0)+isnull(mc.AttachFee,0))-sum(isnull(smpAmount.fee,0)))/sum(isnull(smpAmount.fee,0)) end 实际毛利占比

from BaseOrderInfo fb   
 join Finance_Order_Charges(nolock) bc on fb.BranchCompanyId=bc.CustomerId and fb.系统单号=bc.SystemNo and bc.IncomeOrESxpense='支出' and bc.ChargeTarget=2 and bc.Offset=0  
	
 join Finance_Order_Charges(nolock) mc on fb.CustomerId=mc.CustomerId and fb.系统单号=mc.SystemNo and mc.IncomeOrESxpense='支出' and mc.ChargeTarget=1 and mc.Offset=0  

  left join ( 
	select Number,sum(isnull(SettlementAmount,0)) as fee from xyy_smp.dbo.Compute_ExpenseAmount(nolock) ea
left join xyy_smp.dbo.Compute_ExpenseAmountBatchOperation  (nolock) op on ea.BatchNo=op.BatchNo
where ea.BatchNo = op.BatchNo and ea.CostType=1
group by Number
 )smpAmount on smpAmount.Number=fb.系统单号
 
where  fb.称重时间&gt;'2022-01-01' and  PublicChannelId not in(8,9,15,16,21,32,35,40,42,43,54,55,56,63,64,65) and fb.CustomerId not in(227,294)  
 
group by  fb.产品类型,fb.渠道名称,fb.实际派送渠道,fb.所属客户,fb.业务员,fb.分公司名称,CONVERT(nvarchar(10),称重时间, 120)
order by  fb.产品类型,fb.渠道名称,fb.实际派送渠道,fb.所属客户,fb.业务员,fb.分公司名称,CONVERT(nvarchar(10),称重时间, 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">"LASTTIME:Input",{AFB8E866-2C0E-4E81-8A24-72DFF2845C1B};</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="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="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="32"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[业务员]"
                      name="业务员"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[分公司名称]"
                      codePage="936"
                      dataType="str"
                      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="numeric"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[毛利]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[毛利]"
                      name="毛利"
                      precision="38"
                      scale="4"
                      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="4"
                      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="4"
                      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[称重]"
                      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[票数]"
                      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[Weight_Time]"
                      dataType="wstr"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[Weight_Time]"
                      length="10"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[Weight_Time]"
                      name="Weight_Time"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[产品类型]"
                      codePage="936"
                      dataType="str"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[产品类型]"
                      length="4"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[产品类型]"
                      name="产品类型"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[周]"
                      codePage="936"
                      dataType="str"
                      errorOrTruncationOperation="转换"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[周]"
                      length="13"
                      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="4"
                      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="4"
                      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" />
                  </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="64"
                      name="所属客户" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[业务员]"
                      dataType="wstr"
                      length="32"
                      name="业务员" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[分公司名称]"
                      codePage="936"
                      dataType="str"
                      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="numeric"
                      name="毛利"
                      precision="38"
                      scale="4" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[收入]"
                      dataType="numeric"
                      name="收入"
                      precision="38"
                      scale="4" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[成本]"
                      dataType="numeric"
                      name="成本"
                      precision="38"
                      scale="4" />
                    <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[称重]"
                      dataType="numeric"
                      name="称重"
                      precision="38"
                      scale="6" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[票数]"
                      dataType="i4"
                      name="票数" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[Weight_Time]"
                      dataType="wstr"
                      length="10"
                      name="Weight_Time" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[产品类型]"
                      codePage="936"
                      dataType="str"
                      length="4"
                      name="产品类型" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[周]"
                      codePage="936"
                      dataType="str"
                      length="13"
                      name="周" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[实际成本]"
                      dataType="numeric"
                      name="实际成本"
                      precision="38"
                      scale="4" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[实际毛利]"
                      dataType="numeric"
                      name="实际毛利"
                      precision="38"
                      scale="4" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].ExternalColumns[实际毛利占比]"
                      dataType="numeric"
                      name="实际毛利占比"
                      precision="38"
                      scale="6" />
                  </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[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[产品类型]"
                      codePage="936"
                      dataType="str"
                      length="4"
                      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="32"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[业务员]"
                      name="业务员" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[分公司名称]"
                      codePage="936"
                      dataType="str"
                      length="10"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[分公司名称]"
                      name="分公司名称" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[周]"
                      codePage="936"
                      dataType="str"
                      length="13"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[周]"
                      name="周" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[Weight_Time]"
                      dataType="wstr"
                      length="10"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[Weight_Time]"
                      name="Weight_Time" />
                    <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="numeric"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[称重]"
                      name="称重"
                      precision="38"
                      scale="6" />
                    <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="4" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[收入]"
                      dataType="numeric"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[收入]"
                      name="收入"
                      precision="38"
                      scale="4" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[实际成本]"
                      dataType="numeric"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[实际成本]"
                      name="实际成本"
                      precision="38"
                      scale="4" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[实际毛利]"
                      dataType="numeric"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[实际毛利]"
                      name="实际毛利"
                      precision="38"
                      scale="4" />
                    <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[成本]"
                      dataType="numeric"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[成本]"
                      name="成本"
                      precision="38"
                      scale="4" />
                    <outputColumn
                      refId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[毛利占比]"
                      dataType="numeric"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源错误输出].Columns[毛利占比]"
                      name="毛利占比"
                      precision="38"
                      scale="6" />
                  </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].[BaseETLGroup]</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="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="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="32"
                      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[分公司名称]"
                      cachedCodepage="936"
                      cachedDataType="str"
                      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="numeric"
                      cachedName="毛利"
                      cachedPrecision="38"
                      cachedScale="4"
                      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="4"
                      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="4"
                      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[称重]"
                      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[票数]"
                      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[Weight_Time]"
                      cachedDataType="wstr"
                      cachedLength="10"
                      cachedName="Weight_Time"
                      externalMetadataColumnId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[Weight_Time]"
                      lineageId="Package\数据流任务\OLE DB 源.Outputs[OLE DB 源输出].Columns[Weight_Time]" />
                    <inputColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].Columns[产品类型]"
                      cachedCodepage="936"
                      cachedDataType="str"
                      cachedLength="4"
                      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[周]"
                      cachedCodepage="936"
                      cachedDataType="str"
                      cachedLength="13"
                      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="4"
                      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="4"
                      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[实际毛利占比]" />
                  </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="64"
                      name="所属客户" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[业务员]"
                      dataType="wstr"
                      length="32"
                      name="业务员" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[分公司名称]"
                      codePage="936"
                      dataType="str"
                      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="numeric"
                      name="毛利"
                      precision="38"
                      scale="4" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[收入]"
                      dataType="numeric"
                      name="收入"
                      precision="38"
                      scale="4" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[成本]"
                      dataType="numeric"
                      name="成本"
                      precision="38"
                      scale="4" />
                    <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[称重]"
                      dataType="numeric"
                      name="称重"
                      precision="38"
                      scale="6" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[票数]"
                      dataType="i4"
                      name="票数" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[Weight_Time]"
                      dataType="wstr"
                      length="10"
                      name="Weight_Time" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[产品类型]"
                      codePage="936"
                      dataType="str"
                      length="4"
                      name="产品类型" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[周]"
                      codePage="936"
                      dataType="str"
                      length="13"
                      name="周" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[实际毛利]"
                      dataType="numeric"
                      name="实际毛利"
                      precision="38"
                      scale="4" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[实际成本]"
                      dataType="numeric"
                      name="实际成本"
                      precision="38"
                      scale="4" />
                    <externalMetadataColumn
                      refId="Package\数据流任务\OLE DB 目标.Inputs[OLE DB 目标输入].ExternalColumns[实际毛利占比]"
                      dataType="numeric"
                      name="实际毛利占比"
                      precision="38"
                      scale="6" />
                  </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="{9A59FEDD-01CE-4AF3-AD4F-7C9A84E7744A}"
      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="139.2,41.6"
          Id="Package\数据流任务"
          TopLeft="99.6666629248197,223.714274565785" />
        <NodeLayout
          Size="156.8,41.6"
          Id="Package\执行 SQL 任务"
          TopLeft="155.833327141073,98.4285663998859" />
        <EdgeLayout
          Id="Package.PrecedenceConstraints[Constraint]"
          TopLeft="234.333327141073,140.428566399886">
          <EdgeLayout.Curve>
            <mssgle:Curve
              StartConnector="{assembly:Null}"
              EndConnector="-65.1666642162535,83.2857081658991"
              Start="0,0"
              End="-65.1666642162535,75.7857081658991">
              <mssgle:Curve.Segments>
                <mssgle:SegmentCollection
                  Capacity="5">
                  <mssgle:LineSegment
                    End="0,37.6428540829495" />
                  <mssgle:CubicBezierSegment
                    Point1="0,37.6428540829495"
                    Point2="0,41.6428540829495"
                    Point3="-4,41.6428540829495" />
                  <mssgle:LineSegment
                    End="-61.1666642162535,41.6428540829495" />
                  <mssgle:CubicBezierSegment
                    Point1="-61.1666642162535,41.6428540829495"
                    Point2="-65.1666642162535,41.6428540829495"
                    Point3="-65.1666642162535,45.6428540829495" />
                  <mssgle:LineSegment
                    End="-65.1666642162535,75.7857081658991" />
                </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="144.8,41.6"
          Id="Package\数据流任务\OLE DB 目标"
          TopLeft="200.208325362247,322.214269252457" />
        <NodeLayout
          Size="132.8,41.6"
          Id="Package\数据流任务\OLE DB 源"
          TopLeft="203.833325452275,227.428560090309" />
        <EdgeLayout
          Id="Package\数据流任务.Paths[OLE DB 源输出]"
          TopLeft="271.420825407261,269.028560090309">
          <EdgeLayout.Curve>
            <mssgle:Curve
              StartConnector="{assembly:Null}"
              EndConnector="0,53.185709162148"
              Start="0,0"
              End="0,45.685709162148">
              <mssgle:Curve.Segments>
                <mssgle:SegmentCollection
                  Capacity="5">
                  <mssgle:LineSegment
                    End="0,45.685709162148" />
                </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>