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