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

53.1 Files compared

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

53.2 Comparison summary

Description Between
Files 1 and 2
Text Blocks Lines
Unchanged 5 334
Changed 4 10
Inserted 0 0
Removed 0 0

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

53.4 Active regular expressions

No regular expressions were active.

53.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="{C79C59 12-DB46-4B 17-A4E5-80 7ACA5030A4 }"
  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 ltSyncShad ow"
  13     DTS:Pack ageType="5 "
  14     DTS:Vers ionBuild=" 5"
  15     DTS:Vers ionGUID="{ C3C8429F-2 A12-4B26-9 085-5B427E 60C983}">
  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="{61 AA110C-E3F 5-4861-AC1 9-60F0C7CF 02A0}"
  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:Co nnectionMa nagers>
  30     <DTS:Var iables />
  31     <DTS:Exe cutables>
  32       <DTS:E xecutable
  33         DTS: refId="Pac kage\Execu te SQL Tas k"
  34         DTS: CreationNa me="Micros oft.Execut eSQLTask"
  35         DTS: Descriptio n="Execute  SQL Task"
  36         DTS: DTSID="{46 D77025-9A0 4-41BB-8FA C-778E8500 B893}"
  37         DTS: Executable Type="Micr osoft.Exec uteSQLTask "
  38         DTS: LocaleID=" -1"
  39         DTS: ObjectName ="Execute  SQL Task"
  40         DTS: ThreadHint ="0">
  41         <DTS :Variables  />
  42         <DTS :ObjectDat a>
  43           <S QLTask:Sql TaskData
  44              SQLTask:Co nnection=" {356C7A9E- 5B7E-4A1C- BE76-9B678 1E71E73}"
  45              SQLTask:Sq lStatement Source="EX EC [App].[ uspMasterD oSynchOneC onsultData FromRaw];"  xmlns:SQL Task="www. microsoft. com/sqlser ver/dts/ta sks/sqltas k" />
  46         </DT S:ObjectDa ta>
  47       </DTS: Executable >
  48       <DTS:E xecutable
  49         DTS: refId="Pac kage\Rebui ld Index T ask"
  50         DTS: CreationNa me="Micros oft.DbMain tenanceRei ndexTask"
  51         DTS: Descriptio n="Rebuild  Index Tas k"
  52         DTS: DTSID="{72 0C6ECE-693 0-4E67-A1D F-9A7C7DF0 EE03}"
  53         DTS: Executable Type="Micr osoft.DbMa intenanceR eindexTask "
  54         DTS: LocaleID=" -1"
  55         DTS: ObjectName ="Rebuild  Index Task "
  56         DTS: ThreadHint ="0">
  57         <DTS :Variables  />
  58         <DTS :ObjectDat a>
  59           <S QLTask:Sql TaskData
  60              SQLTask:Co nnection=" {61AA110C- E3F5-4861- AC19-60F0C 7CF02A0}"
  61              SQLTask:Da tabaseSele ctionType= "4"
  62              SQLTask:Ta bleSelecti onType="1"
  63              SQLTask:Ob jectType=" 0"
  64              SQLTask:Se rverVersio n="13"
  65              SQLTask:Ex tendedLogg ing="True"
  66              SQLTask:Lo calConnect ionForLogg ing=""
  67              SQLTask:Ta skName=""
  68              SQLTask:Ig noreDataba sesInNotOn lineState= "False"
  69              SQLTask:Us eOriginalA mount="Tru e"
  70              SQLTask:Pe rcentage=" 20"
  71              SQLTask:So rt="True"
  72              SQLTask:Ke epOnline=" False"
  73              SQLTask:Sk ipUnsuppor ted="False "
  74              SQLTask:Pa dIndex="Tr ue"
  75              SQLTask:Ma ximumDegre eOfParalle lismUsed=" False"
  76              SQLTask:Lo wPriorityU sed="False "
  77              SQLTask:Ch eckFragmen tationPerc entUsed="T rue"
  78              SQLTask:Ch eckPageCou ntUsed="Fa lse"
  79              SQLTask:Fr agmentatio nOp="Fast"
  80              SQLTask:Fr agmentatio nPercent=" 30"
  81              SQLTask:Ch eckLastUsa geInDaysUs ed="False"  xmlns:SQL Task="www. microsoft. com/sqlser ver/dts/ta sks/sqltas k">
  82              <SQLTask:S electedDat abases
  83                SQLTask: DatabaseNa me="CBOPC_ EPRS_Shado w" />
  84              <SQLTask:S electedTab les
  85                SQLTask: TableName= "APP.Batch Logs" />
  86              <SQLTask:S electedTab les
  87                SQLTask: TableName= "APP.OneCo nsults" />
  88              <SQLTask:S electedTab les
  89                SQLTask: TableName= "APP.Regio ns" />
  90              <SQLTask:S electedTab les
  91                SQLTask: TableName= "APP.Reque stServices " />
  92              <SQLTask:S electedTab les
  93                SQLTask: TableName= "APP.Stati ons" />
  94              <SQLTask:S electedTab les
  95                SQLTask: TableName= "APP.Statu sTypes" />
  96              <SQLTask:S electedTab les
  97                SQLTask: TableName= "APP.Visns " />
  98              <SQLTask:S electedTab les
  99                SQLTask: TableName= "zraw._con Consult" / >
  100           </ SQLTask:Sq lTaskData>
  101         </DT S:ObjectDa ta>
  102       </DTS: Executable >
  103     </DTS:Ex ecutables>
  104     <DTS:Pre cedenceCon straints>
  105       <DTS:P recedenceC onstraint
  106         DTS: refId="Pac kage.Prece denceConst raints[Con straint]"
  107         DTS: CreationNa me=""
  108         DTS: DTSID="{DE DFDC1D-372 A-4644-95C D-B4EAB536 96A4}"
  109         DTS: From="Pack age\Execut e SQL Task "
  110         DTS: LogicalAnd ="True"
  111         DTS: ObjectName ="Constrai nt"
  112         DTS: To="Packag e\Rebuild  Index Task " />
  113     </DTS:Pr ecedenceCo nstraints>
  114     <DTS:Des ignTimePro perties><! [CDATA[<?x ml version ="1.0"?>
  115   <!--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.- ->
  116   <!--If you  manually  edit this  section an d make a m istake, yo u can dele te it. -->
  117   <!--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.-->
  118   <Objects
  119     Version= "8">
  120     <!--Each  node belo w will con tain prope rties that  do not af fect runti me behavio r.-->
  121     <Package
  122       design -time-name ="Package" >
  123       <Layou tInfo>
  124         <Gra phLayout
  125           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 ">
  126           <N odeLayout
  127              Size="164, 41.6"
  128              Id="Packag e\Execute  SQL Task"
  129              TopLeft="1 16.5714305 56628,61.1 7647144621 22" />
  130           <N odeLayout
  131              Size="170. 4,41.6"
  132              Id="Packag e\Rebuild  Index Task "
  133              TopLeft="1 81.7142888 08862,187. 8117673398 71" />
  134           <E dgeLayout
  135              Id="Packag e.Preceden ceConstrai nts[Constr aint]"
  136              TopLeft="1 98.5714305 56628,102. 7764714462 12">
  137              <EdgeLayou t.Curve>
  138                <mssgle: Curve
  139                  StartC onnector=" {assembly: Null}"
  140                  EndCon nector="68 .342858252 2335,85.03 5295893659 1"
  141                  Start= "0,0"
  142                  End="6 8.34285825 22335,77.5 3529589365 91">
  143                  <mssgl e:Curve.Se gments>
  144                    <mss gle:Segmen tCollectio n
  145                      Ca pacity="5" >
  146                      <m ssgle:Line Segment
  147                         End="0,38. 5176479468 295" />
  148                      <m ssgle:Cubi cBezierSeg ment
  149                         Point1="0, 38.5176479 468295"
  150                         Point2="0, 42.5176479 468295"
  151                         Point3="4, 42.5176479 468295" />
  152                      <m ssgle:Line Segment
  153                         End="64.34 2858252233 5,42.51764 79468295"  />
  154                      <m ssgle:Cubi cBezierSeg ment
  155                         Point1="64 .342858252 2335,42.51 7647946829 5"
  156                         Point2="68 .342858252 2335,42.51 7647946829 5"
  157                         Point3="68 .342858252 2335,46.51 7647946829 5" />
  158                      <m ssgle:Line Segment
  159                         End="68.34 2858252233 5,77.53529 58936591"  />
  160                    </ms sgle:Segme ntCollecti on>
  161                  </mssg le:Curve.S egments>
  162                </mssgle :Curve>
  163              </EdgeLayo ut.Curve>
  164              <EdgeLayou t.Labels>
  165                <EdgeLab elCollecti on />
  166              </EdgeLayo ut.Labels>
  167           </ EdgeLayout >
  168         </Gr aphLayout>
  169       </Layo utInfo>
  170     </Packag e>
  171   </Objects> ]]></DTS:D esignTimeP roperties>
  172   </DTS:Exec utable>