212. EPMO Open Source Coordination Office Redaction File Detail Report

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

212.1 Files compared

# Location File Last Modified
1 C:\AraxisMergeCompare\Pri_un\EPRS\EPRS_SSIS\EPRS.SSIS\EPRS.SSIS extCon_OneConsultSyncShadow.dtsx Thu Apr 18 16:53:26 2019 UTC
2 C:\AraxisMergeCompare\Pri_re\EPRS\EPRS_SSIS\EPRS.SSIS\EPRS.SSIS extCon_OneConsultSyncShadow.dtsx Wed May 1 12:41:59 2019 UTC

212.2 Comparison summary

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

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

212.4 Active regular expressions

No regular expressions were active.

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