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.
# | 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 |
Description | Between Files 1 and 2 |
|
---|---|---|
Text Blocks | Lines | |
Unchanged | 8 | 352 |
Changed | 7 | 16 |
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="{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> |
Araxis Merge (but not the data content of this report) is Copyright © 1993-2016 Araxis Ltd (www.araxis.com). All rights reserved.