52. EPMO Open Source Coordination Office Redaction File Detail Report

Produced by Araxis Merge on 5/2/2019 1:17:51 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.

52.1 Files compared

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

52.2 Comparison summary

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

52.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

52.4 Active regular expressions

No regular expressions were active.

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