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.
# | Location | File | Last Modified |
---|---|---|---|
1 | C:\AraxisMergeCompare\Pri_un\EPRS\EPRS_SSIS\EPRS.SSIS\EPRS.SSIS\obj\Development | extCon_OneConsultSyncShadow.dtsx | Thu Apr 18 16:53:28 2019 UTC |
2 | C:\AraxisMergeCompare\Pri_re\EPRS\EPRS_SSIS\EPRS.SSIS\EPRS.SSIS\obj\Development | extCon_OneConsultSyncShadow.dtsx | Tue Apr 30 14:40:20 2019 UTC |
Description | Between Files 1 and 2 |
|
---|---|---|
Text Blocks | Lines | |
Unchanged | 5 | 336 |
Changed | 4 | 10 |
Inserted | 0 | 0 |
Removed | 0 | 0 |
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 |
No regular expressions were active.
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.92" | |
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> |
Araxis Merge (but not the data content of this report) is Copyright © 1993-2016 Araxis Ltd (www.araxis.com). All rights reserved.