70. EPMO Open Source Coordination Office Redaction File Detail Report

Produced by Araxis Merge on 5/2/2019 1:17:58 PM Central Daylight Time. See www.araxis.com for information about Merge. This report uses XHTML and CSS2, and is best viewed with a modern standards-compliant browser. For optimum results when printing this report, use landscape orientation and enable printing of background images and colours in your browser.

70.1 Files compared

# Location File Last Modified
1 C:\AraxisMergeCompare\Pri_un\EPRS\EPRS_SSIS\EPRS.SSIS\EPRS.SSIS\obj\Development extCon_OneConsultSync.dtsx Thu Apr 18 16:53:28 2019 UTC
2 C:\AraxisMergeCompare\Pri_re\EPRS\EPRS_SSIS\EPRS.SSIS\EPRS.SSIS\obj\Development extCon_OneConsultSync.dtsx Tue Apr 30 14:40:00 2019 UTC

70.2 Comparison summary

Description Between
Files 1 and 2
Text Blocks Lines
Unchanged 8 354
Changed 7 16
Inserted 0 0
Removed 0 0

70.3 Comparison options

Whitespace
Character case Differences in character case are significant
Line endings Differences in line endings (CR and LF characters) are ignored
CR/LF characters Not shown in the comparison detail

70.4 Active regular expressions

No regular expressions were active.

70.5 Comparison detail

  1   <?xml vers ion="1.0"? >
  2   <DTS:Execu table xmln s:DTS="www .microsoft .com/SqlSe rver/Dts"
  3     DTS:refI d="Package "
  4     DTS:Crea tionDate=" 3/23/2018  7:01:00 AM "
  5     DTS:Crea tionName=" Microsoft. Package"
  6       DTS:Creato rComputerN ame=" DNS "
  7       DTS:Creato rName=" DOM A IN \ DNS     DANCYJ"
  8     DTS:DTSI D="{170257 FF-412C-41 54-84DE-DF 6EB686E427 }"
  9     DTS:Exec utableType ="Microsof t.Package"
  10     DTS:Last ModifiedPr oductVersi on="14.0.3 002.92"
  11     DTS:Loca leID="1033 "
  12     DTS:Obje ctName="ex tCon_OneCo nsultSync"
  13     DTS:Pack ageType="5 "
  14     DTS:Prot ectionLeve l="0"
  15     DTS:Vers ionBuild=" 7"
  16     DTS:Vers ionGUID="{ F5E4B805-8 CD3-46AA-9 35F-518CB3 6014D1}">
  17     <DTS:Pro perty
  18       DTS:Na me="Packag eFormatVer sion">8</D TS:Propert y>
  19     <DTS:Con nectionMan agers>
  20       <DTS:C onnectionM anager
  21           DTS:refId= "Package.C onnectionM anagers[ DNS             . DNS             .CBOPC_EPR S_Shadow]"
  22         DTS: CreationNa me="ADO.NE T:SQL"
  23         DTS: DTSID="{E4 CBECAA-B84 8-497E-992 6-8C8DD245 B33E}"
  24           DTS:Object Name=" DNS             . DNS             .CBOPC_EPR S_Shadow">
  25         <DTS :ObjectDat a>
  26           <D TS:Connect ionManager
  27               DTS:Connec tionString ="Data Sou rce= DNS             . DNS             ;Integrate d Security =SSPI;Conn ect Timeou t=30;" />
  28         </DT S:ObjectDa ta>
  29       </DTS: Connection Manager>
  30       <DTS:C onnectionM anager
  31           DTS:refId= "Package.C onnectionM anagers[ DNS             . DNS             .CBOPC_EPR S]"
  32         DTS: CreationNa me="ADO.NE T:SQL"
  33         DTS: DTSID="{E1 F8A8A0-B1E A-4D30-893 7-5B2AF344 9532}"
  34           DTS:Object Name=" DNS             . DNS             .CBOPC_EPR S">
  35         <DTS :ObjectDat a>
  36           <D TS:Connect ionManager
  37               DTS:Connec tionString ="Data Sou rce= DNS             . DNS             ;Integrate d Security =SSPI;Conn ect Timeou t=30;" />
  38         </DT S:ObjectDa ta>
  39       </DTS: Connection Manager>
  40     </DTS:Co nnectionMa nagers>
  41     <DTS:Var iables />
  42     <DTS:Exe cutables>
  43       <DTS:E xecutable
  44         DTS: refId="Pac kage\Execu te SQL Tas k"
  45         DTS: CreationNa me="Micros oft.Execut eSQLTask"
  46         DTS: Descriptio n="Execute  SQL Task"
  47         DTS: DTSID="{2A E0A909-370 B-4845-945 D-8881ADBC 16AD}"
  48         DTS: Executable Type="Micr osoft.Exec uteSQLTask "
  49         DTS: LocaleID=" -1"
  50         DTS: ObjectName ="Execute  SQL Task"
  51         DTS: ThreadHint ="0">
  52         <DTS :Variables  />
  53         <DTS :ObjectDat a>
  54           <S QLTask:Sql TaskData
  55              SQLTask:Co nnection=" {CA06F0CF- F25E-48DC- 84F4-7E552 846C904}"
  56              SQLTask:Sq lStatement Source="EX EC [App].[ uspMasterD oSynchOneC onsultData FromRaw];"  xmlns:SQL Task="www. microsoft. com/sqlser ver/dts/ta sks/sqltas k" />
  57         </DT S:ObjectDa ta>
  58       </DTS: Executable >
  59       <DTS:E xecutable
  60         DTS: refId="Pac kage\Rebui ld Index T ask"
  61         DTS: CreationNa me="Micros oft.DbMain tenanceRei ndexTask"
  62         DTS: Descriptio n="Rebuild  Index Tas k"
  63         DTS: DTSID="{13 E7CF95-C23 5-41A8-B8D 5-91AAB2B4 5FC4}"
  64         DTS: Executable Type="Micr osoft.DbMa intenanceR eindexTask "
  65         DTS: LocaleID=" -1"
  66         DTS: ObjectName ="Rebuild  Index Task "
  67         DTS: ThreadHint ="0">
  68         <DTS :Variables  />
  69         <DTS :ObjectDat a>
  70           <S QLTask:Sql TaskData
  71              SQLTask:Co nnection=" {E1F8A8A0- B1EA-4D30- 8937-5B2AF 3449532}"
  72              SQLTask:Da tabaseSele ctionType= "4"
  73              SQLTask:Ta bleSelecti onType="1"
  74              SQLTask:Ob jectType=" 0"
  75              SQLTask:Se rverVersio n="13"
  76              SQLTask:Ex tendedLogg ing="True"
  77              SQLTask:Lo calConnect ionForLogg ing=""
  78              SQLTask:Ta skName=""
  79              SQLTask:Ig noreDataba sesInNotOn lineState= "False"
  80              SQLTask:Us eOriginalA mount="Tru e"
  81              SQLTask:Pe rcentage=" 20"
  82              SQLTask:So rt="True"
  83              SQLTask:Ke epOnline=" False"
  84              SQLTask:Sk ipUnsuppor ted="False "
  85              SQLTask:Pa dIndex="Tr ue"
  86              SQLTask:Ma ximumDegre eOfParalle lismUsed=" False"
  87              SQLTask:Lo wPriorityU sed="False "
  88              SQLTask:Ch eckFragmen tationPerc entUsed="T rue"
  89              SQLTask:Ch eckPageCou ntUsed="Fa lse"
  90              SQLTask:Fr agmentatio nOp="Fast"
  91              SQLTask:Fr agmentatio nPercent=" 15"
  92              SQLTask:Ch eckLastUsa geInDaysUs ed="False"  xmlns:SQL Task="www. microsoft. com/sqlser ver/dts/ta sks/sqltas k">
  93              <SQLTask:S electedDat abases
  94                SQLTask: DatabaseNa me="CBOPC_ EPRS" />
  95              <SQLTask:S electedTab les
  96                SQLTask: TableName= "App.Batch Logs" />
  97              <SQLTask:S electedTab les
  98                SQLTask: TableName= "App.DimDu rationPeri ods" />
  99              <SQLTask:S electedTab les
  100                SQLTask: TableName= "App.OneCo nsults" />
  101              <SQLTask:S electedTab les
  102                SQLTask: TableName= "App.Regio ns" />
  103              <SQLTask:S electedTab les
  104                SQLTask: TableName= "App.Reque stServices " />
  105              <SQLTask:S electedTab les
  106                SQLTask: TableName= "App.Stati ons" />
  107              <SQLTask:S electedTab les
  108                SQLTask: TableName= "App.Statu sTypes" />
  109              <SQLTask:S electedTab les
  110                SQLTask: TableName= "App.Visns " />
  111              <SQLTask:S electedTab les
  112                SQLTask: TableName= "zraw._con Consult" / >
  113           </ SQLTask:Sq lTaskData>
  114         </DT S:ObjectDa ta>
  115       </DTS: Executable >
  116     </DTS:Ex ecutables>
  117     <DTS:Pre cedenceCon straints>
  118       <DTS:P recedenceC onstraint
  119         DTS: refId="Pac kage.Prece denceConst raints[Con straint]"
  120         DTS: CreationNa me=""
  121         DTS: DTSID="{08 E28DF7-1DD 1-4986-BB9 0-87EC5ED8 201D}"
  122         DTS: From="Pack age\Execut e SQL Task "
  123         DTS: LogicalAnd ="True"
  124         DTS: ObjectName ="Constrai nt"
  125         DTS: To="Packag e\Rebuild  Index Task " />
  126     </DTS:Pr ecedenceCo nstraints>
  127     <DTS:Des ignTimePro perties><! [CDATA[<?x ml version ="1.0"?>
  128   <!--This C DATA secti on contain s the layo ut informa tion of th e package.  The secti on include s informat ion such a s (x,y) co ordinates,  width, an d height.- ->
  129   <!--If you  manually  edit this  section an d make a m istake, yo u can dele te it. -->
  130   <!--The pa ckage will  still be  able to lo ad normall y but the  previous l ayout info rmation wi ll be lost  and the d esigner wi ll automat ically re- arrange th e elements  on the de sign surfa ce.-->
  131   <Objects
  132     Version= "8">
  133     <!--Each  node belo w will con tain prope rties that  do not af fect runti me behavio r.-->
  134     <Package
  135       design -time-name ="Package" >
  136       <Layou tInfo>
  137         <Gra phLayout
  138           Ca pacity="4"  xmlns="cl r-namespac e:Microsof t.SqlServe r.Integrat ionService s.Designer .Model.Ser ialization ;assembly= Microsoft. SqlServer. Integratio nServices. Graph" xml ns:mssgle= "clr-names pace:Micro soft.SqlSe rver.Graph .LayoutEng ine;assemb ly=Microso ft.SqlServ er.Graph"  xmlns:x="h ttp://sche mas.micros oft.com/wi nfx/2006/x aml">
  139           <N odeLayout
  140              Size="164, 42"
  141              Id="Packag e\Execute  SQL Task"
  142              TopLeft="1 16.5714305 56628,61.1 7647144621 22" />
  143           <N odeLayout
  144              Size="170, 42"
  145              Id="Packag e\Rebuild  Index Task "
  146              TopLeft="1 93.1428604 3206,172.5 1764947831 8" />
  147           <E dgeLayout
  148              Id="Packag e.Preceden ceConstrai nts[Constr aint]"
  149              TopLeft="1 98.5714305 56628,102. 7764714462 12">
  150              <EdgeLayou t.Curve>
  151                <mssgle: Curve
  152                  StartC onnector=" {x:Null}"
  153                  EndCon nector="79 .771429875 4324,69.74 1178032106 "
  154                  Start= "0,0"
  155                  End="7 9.77142987 54324,62.2 4117803210 6">
  156                  <mssgl e:Curve.Se gments>
  157                    <mss gle:Segmen tCollectio n
  158                      Ca pacity="5" >
  159                      <m ssgle:Line Segment
  160                         End="0,30. 8705890160 53" />
  161                      <m ssgle:Cubi cBezierSeg ment
  162                         Point1="0, 30.8705890 16053"
  163                         Point2="0, 34.8705890 16053"
  164                         Point3="4, 34.8705890 16053" />
  165                      <m ssgle:Line Segment
  166                         End="75.77 1429875432 4,34.87058 9016053" / >
  167                      <m ssgle:Cubi cBezierSeg ment
  168                         Point1="75 .771429875 4324,34.87 0589016053 "
  169                         Point2="79 .771429875 4324,34.87 0589016053 "
  170                         Point3="79 .771429875 4324,38.87 0589016053 " />
  171                      <m ssgle:Line Segment
  172                         End="79.77 1429875432 4,62.24117 8032106" / >
  173                    </ms sgle:Segme ntCollecti on>
  174                  </mssg le:Curve.S egments>
  175                </mssgle :Curve>
  176              </EdgeLayo ut.Curve>
  177              <EdgeLayou t.Labels>
  178                <EdgeLab elCollecti on />
  179              </EdgeLayo ut.Labels>
  180           </ EdgeLayout >
  181         </Gr aphLayout>
  182       </Layo utInfo>
  183     </Packag e>
  184   </Objects> ]]></DTS:D esignTimeP roperties>
  185   </DTS:Exec utable>