UT_COD_PROYECTOS/UT-COD_PROYECTOS/UT-COD_PROYECTOS/UT-FAC_GENERACION_OBLIGADAT1.dtsx

<?xml version="1.0"?>
<DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts"
  DTS:refId="Package"
  DTS:CreationDate="9/30/2020 2:45:29 PM"
  DTS:CreationName="Microsoft.Package"
  DTS:CreatorComputerName="RUIZ"
  DTS:CreatorName="GRUPOME\druiz"
  DTS:DTSID="{1589333A-DCD1-4D47-8EC1-063BF564013B}"
  DTS:ExecutableType="Microsoft.Package"
  DTS:LastModifiedProductVersion="15.0.2000.121"
  DTS:LocaleID="1033"
  DTS:ObjectName="UT-FAC_GENERACION_OBLIGADAT1"
  DTS:PackageType="5"
  DTS:VersionBuild="2"
  DTS:VersionGUID="{B0D5BB11-C6ED-4C46-A24B-B3B86C7EE2D0}">
  <DTS:Property
    DTS:Name="PackageFormatVersion">8</DTS:Property>
  <DTS:Variables />
  <DTS:Executables>
    <DTS:Executable
      DTS:refId="Package\COD PROYECTO"
      DTS:CreationName="Microsoft.ExecuteSQLTask"
      DTS:Description="Execute SQL Task"
      DTS:DTSID="{1EA45D56-46F3-47FB-B8CA-A88790C1DEAD}"
      DTS:ExecutableType="Microsoft.ExecuteSQLTask"
      DTS:LocaleID="-1"
      DTS:ObjectName="COD PROYECTO"
      DTS:TaskContact="Execute SQL Task; Microsoft Corporation; SQL Server 2019; © 2019 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1"
      DTS:ThreadHint="0">
      <DTS:Variables />
      <DTS:ObjectData>
        <SQLTask:SqlTaskData
          SQLTask:Connection="{C795B859-49C9-4952-8EC8-B3DA2B9B7F89}"
          SQLTask:SqlStatementSource="UPDATE UT.FAC_GENERACION_OBLIGADA_T1&#xA;  SET &#xA;      UT.FAC_GENERACION_OBLIGADA_T1.COD_PROYECTO = PR.COD_PROYECTO&#xA;FROM&#xA;(&#xA;    SELECT COD_PROYECTO, &#xA;           M_OPE, &#xA;           Y_OPE, &#xA;           FECHA_INICIO, &#xA;           FECHA_FIN, &#xA;           PUNTO_MEDIDA&#xA;    FROM CONCILIACION.PROYECTOS&#xA;) AS PR&#xA;WHERE UT.FAC_GENERACION_OBLIGADA_T1.COD_EQUIPO = PR.PUNTO_MEDIDA&#xA;      --AND MONTH(UT.FAC_INYECCIONES.FECHA)=PR.M_OPE&#xA;      --AND YEAR(UT.FAC_INYECCIONES.FECHA)=PR.Y_OPE&#xA;      AND UT.FAC_GENERACION_OBLIGADA_T1.FECHA &gt;= PR.FECHA_INICIO&#xA;      AND UT.FAC_GENERACION_OBLIGADA_T1.FECHA &lt;= PR.FECHA_FIN&#xA;&#x9;  AND UT.FAC_GENERACION_OBLIGADA_T1.COD_PM='c08'&#xA;&#x9;  AND UT.FAC_GENERACION_OBLIGADA_T1.FECHA &gt;= DATEADD(DAY, -62, GETDATE())" xmlns:SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask" />
      </DTS:ObjectData>
    </DTS:Executable>
  </DTS:Executables>
  <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">
        <NodeLayout
          Size="156,42"
          Id="Package\COD PROYECTO"
          TopLeft="415,279" />
      </GraphLayout>
    </LayoutInfo>
  </Package>
</Objects>]]></DTS:DesignTimeProperties>
</DTS:Executable>