Produced by Araxis Merge on 5/2/2019 1:18:56 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 | Transfermation HCFAEdit-CookieCutter.dtsx | Thu Apr 18 16:53:26 2019 UTC |
2 | C:\AraxisMergeCompare\Pri_re\EPRS\EPRS_SSIS\EPRS.SSIS\EPRS.SSIS | Transfermation HCFAEdit-CookieCutter.dtsx | Wed May 1 13:06:11 2019 UTC |
Description | Between Files 1 and 2 |
|
---|---|---|
Text Blocks | Lines | |
Unchanged | 4 | 1618 |
Changed | 3 | 8 |
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=" 10/31/2017 2:52:51 P M" | |
5 | DTS:Crea tionName=" Microsoft. Package" | |
6 | DTS:Creato rComputerN ame="
|
|
7 | DTS:Creato rName=" DN S \ DNS ballje" | |
8 | DTS:Desc ription="D TS Wizard- generated package" | |
9 | DTS:DTSI D="{A70A94 25-5448-43 5E-B26B-E7 235D152428 }" | |
10 | DTS:Exec utableType ="Microsof t.Package" | |
11 | DTS:Last ModifiedPr oductVersi on="14.0.0 800.90" | |
12 | DTS:Loca leID="1033 " | |
13 | DTS:MaxE rrorCount= "0" | |
14 | DTS:Obje ctName="Tr ansfermati on HCFAEdi t-CookieCu tter" | |
15 | DTS:Vers ionBuild=" 1" | |
16 | DTS:Vers ionGUID="{ 8347D144-E 267-41BD-8 D83-F039BF C7FDDF}"> | |
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="Pac kage.Conne ctionManag ers[Destin ationConne ctionOLEDB ]" | |
22 | DTS: CreationNa me="OLEDB" | |
23 | DTS: DTSID="{5B F9D14D-CDA 1-400D-882 C-E108776A 51C0}" | |
24 | DTS: ObjectName ="Destinat ionConnect ionOLEDB"> | |
25 | <DTS :ObjectDat a> | |
26 | <D TS:Connect ionManager | |
27 | DTS:Connec tionString ="Data Sou rce= DNS ;Initial C atalog=EPR S_Shadow;P rovider=SQ LNCLI11;In tegrated S ecurity=SS PI;Auto Tr anslate=fa lse;" /> | |
28 | </DT S:ObjectDa ta> | |
29 | </DTS: Connection Manager> | |
30 | <DTS:C onnectionM anager | |
31 | DTS: refId="Pac kage.Conne ctionManag ers[Source Connection OLEDB]" | |
32 | DTS: CreationNa me="OLEDB" | |
33 | DTS: DTSID="{70 AD6EBE-9FF E-440E-8AD F-6F5F4EDB 227D}" | |
34 | DTS: ObjectName ="SourceCo nnectionOL EDB"> | |
35 | <DTS :ObjectDat a> | |
36 | <D TS:Connect ionManager | |
37 | DTS:Connec tionString ="Data Sou rce= DNS ;Initial C atalog=EPR S_Shadow;P rovider=SQ LNCLI11;In tegrated S ecurity=SS PI;Auto Tr anslate=fa lse;" /> | |
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\Data Flow Task 1" | |
45 | DTS: CreationNa me="Micros oft.Pipeli ne" | |
46 | DTS: DelayValid ation="Tru e" | |
47 | DTS: DTSID="{86 D9FD5F-56B 3-439C-994 4-1AD7F588 8F71}" | |
48 | DTS: Executable Type="Micr osoft.Pipe line" | |
49 | DTS: FailPackag eOnFailure ="True" | |
50 | DTS: LocaleID=" -1" | |
51 | DTS: ObjectName ="Data Flo w Task 1" | |
52 | DTS: TaskContac t="Perform s high-per formance d ata extrac tion, tran sformation and loadi ng;Microso ft Corpora tion; Micr osoft SQL Server; (C ) Microsof t Corporat ion; All R ights Rese rved;http: //www.micr osoft.com/ sql/suppor t/default. asp;1"> | |
53 | <DTS :Variables /> | |
54 | <DTS :ObjectDat a> | |
55 | <p ipeline | |
56 | defaultBuf ferSize="3 145728" | |
57 | version="1 "> | |
58 | <component s> | |
59 | <compone nt | |
60 | refId= "Package\D ata Flow T ask 1\Dest ination - FBCSHCFAEd it" | |
61 | compon entClassID ="Microsof t.OLEDBDes tination" | |
62 | contac tInfo="OLE DB Destin ation;Micr osoft Corp oration; M icrosoft S QL Server; (C) Micro soft Corpo ration; Al l Rights R eserved; h ttp://www. microsoft. com/sql/su pport;4" | |
63 | descri ption="OLE DB Destin ation" | |
64 | name=" Destinatio n - FBCSHC FAEdit" | |
65 | usesDi spositions ="true" | |
66 | valida teExternal Metadata=" False" | |
67 | versio n="4"> | |
68 | <prope rties> | |
69 | <pro perty | |
70 | da taType="Sy stem.Int32 " | |
71 | de scription= "The numbe r of secon ds before a command times out. A value of 0 indic ates an in finite tim e-out." | |
72 | na me="Comman dTimeout"> 0</propert y> | |
73 | <pro perty | |
74 | da taType="Sy stem.Strin g" | |
75 | de scription= "Specifies the name of the dat abase obje ct used to open a ro wset." | |
76 | na me="OpenRo wset">[Cal lCenter].[ FBCSHCFAEd it]</prope rty> | |
77 | <pro perty | |
78 | da taType="Sy stem.Strin g" | |
79 | de scription= "Specifies the varia ble that c ontains th e name of the databa se object used to op en a rowse t." | |
80 | na me="OpenRo wsetVariab le"></prop erty> | |
81 | <pro perty | |
82 | da taType="Sy stem.Strin g" | |
83 | de scription= "The SQL c ommand to be execute d." | |
84 | na me="SqlCom mand" | |
85 | UI TypeEditor ="Microsof t.DataTran sformation Services.C ontrols.Mo dalMultili neStringEd itor, Micr osoft.Data Transforma tionServic es.Control s, Version =14.0.0.0, Culture=n eutral, Pu blicKeyTok en=89845dc d8080cc91" ></propert y> | |
86 | <pro perty | |
87 | da taType="Sy stem.Int32 " | |
88 | de scription= "Specifies the colum n code pag e to use w hen code p age inform ation is u navailable from the data sourc e." | |
89 | na me="Defaul tCodePage" >1252</pro perty> | |
90 | <pro perty | |
91 | da taType="Sy stem.Boole an" | |
92 | de scription= "Forces th e use of t he Default CodePage p roperty va lue when d escribing character data." | |
93 | na me="Always UseDefault CodePage"> false</pro perty> | |
94 | <pro perty | |
95 | da taType="Sy stem.Int32 " | |
96 | de scription= "Specifies the mode used to ac cess the d atabase." | |
97 | na me="Access Mode" | |
98 | ty peConverte r="AccessM ode">3</pr operty> | |
99 | <pro perty | |
100 | da taType="Sy stem.Boole an" | |
101 | de scription= "Indicates whether t he values supplied f or identit y columns will be co pied to th e destinat ion. If fa lse, value s for iden tity colum ns will be auto-gene rated at t he destina tion. Appl ies only i f fast loa d is turne d on." | |
102 | na me="FastLo adKeepIden tity">true </property > | |
103 | <pro perty | |
104 | da taType="Sy stem.Boole an" | |
105 | de scription= "Indicates whether t he columns containin g null wil l have nul l inserted in the de stination. If false, columns c ontaining null will have their default v alues inse rted at th e destinat ion. Appli es only if fast load is turned on." | |
106 | na me="FastLo adKeepNull s">false</ property> | |
107 | <pro perty | |
108 | da taType="Sy stem.Strin g" | |
109 | de scription= "Specifies options t o be used with fast load. App lies only if fast lo ad is turn ed on." | |
110 | na me="FastLo adOptions" >TABLOCK,C HECK_CONST RAINTS</pr operty> | |
111 | <pro perty | |
112 | da taType="Sy stem.Int32 " | |
113 | de scription= "Specifies when comm its are is sued durin g data ins ertion. A value of 0 specifie s that one commit wi ll be issu ed at the end of dat a insertio n. Applie s only if fast load is turned on." | |
114 | na me="FastLo adMaxInser tCommitSiz e">2147483 647</prope rty> | |
115 | </prop erties> | |
116 | <conne ctions> | |
117 | <con nection | |
118 | re fId="Packa ge\Data Fl ow Task 1\ Destinatio n - FBCSHC FAEdit.Con nections[O leDbConnec tion]" | |
119 | co nnectionMa nagerID="P ackage.Con nectionMan agers[Dest inationCon nectionOLE DB]" | |
120 | co nnectionMa nagerRefId ="Package. Connection Managers[D estination Connection OLEDB]" | |
121 | de scription= "The OLE D B runtime connection used to a ccess the database." | |
122 | na me="OleDbC onnection" /> | |
123 | </conn ections> | |
124 | <input s> | |
125 | <inp ut | |
126 | re fId="Packa ge\Data Fl ow Task 1\ Destinatio n - FBCSHC FAEdit.Inp uts[Destin ation Inpu t]" | |
127 | er rorOrTrunc ationOpera tion="Inse rt" | |
128 | er rorRowDisp osition="F ailCompone nt" | |
129 | ha sSideEffec ts="true" | |
130 | na me="Destin ation Inpu t"> | |
131 | <i nputColumn s> | |
132 | <inputColu mn | |
133 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAEdit .Inputs[De stination Input].Col umns[stati on__no]" | |
134 | cachedCo depage="12 52" | |
135 | cachedDa taType="st r" | |
136 | cachedLe ngth="30" | |
137 | cachedNa me="statio n__no" | |
138 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAEdit. Inputs[Des tination I nput].Exte rnalColumn s[StationN umber]" | |
139 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Output] .Columns[s tation__no ]" /> | |
140 | <inputColu mn | |
141 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAEdit .Inputs[De stination Input].Col umns[hcfai d]" | |
142 | cachedDa taType="i8 " | |
143 | cachedNa me="hcfaid " | |
144 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAEdit. Inputs[Des tination I nput].Exte rnalColumn s[HFCA_ID] " | |
145 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Output] .Columns[h cfaid]" /> | |
146 | <inputColu mn | |
147 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAEdit .Inputs[De stination Input].Col umns[id]" | |
148 | cachedDa taType="i8 " | |
149 | cachedNa me="id" | |
150 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAEdit. Inputs[Des tination I nput].Exte rnalColumn s[Row_ID]" | |
151 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Output] .Columns[i d]" /> | |
152 | <inputColu mn | |
153 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAEdit .Inputs[De stination Input].Col umns[linei tem]" | |
154 | cachedDa taType="i8 " | |
155 | cachedNa me="lineit em" | |
156 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAEdit. Inputs[Des tination I nput].Exte rnalColumn s[LineItem ]" | |
157 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Output] .Columns[l ineitem]" /> | |
158 | <inputColu mn | |
159 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAEdit .Inputs[De stination Input].Col umns[editc ode]" | |
160 | cachedCo depage="12 52" | |
161 | cachedDa taType="st r" | |
162 | cachedLe ngth="8000 " | |
163 | cachedNa me="editco de" | |
164 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAEdit. Inputs[Des tination I nput].Exte rnalColumn s[EditCode ]" | |
165 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Output] .Columns[e ditcode]" /> | |
166 | <inputColu mn | |
167 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAEdit .Inputs[De stination Input].Col umns[edits ubcode]" | |
168 | cachedCo depage="12 52" | |
169 | cachedDa taType="st r" | |
170 | cachedLe ngth="8000 " | |
171 | cachedNa me="editsu bcode" | |
172 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAEdit. Inputs[Des tination I nput].Exte rnalColumn s[EditSubC ode]" | |
173 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Output] .Columns[e ditsubcode ]" /> | |
174 | <inputColu mn | |
175 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAEdit .Inputs[De stination Input].Col umns[editm sg]" | |
176 | cachedCo depage="12 52" | |
177 | cachedDa taType="st r" | |
178 | cachedLe ngth="8000 " | |
179 | cachedNa me="editms g" | |
180 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAEdit. Inputs[Des tination I nput].Exte rnalColumn s[EditMsg] " | |
181 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Output] .Columns[e ditmsg]" / > | |
182 | <inputColu mn | |
183 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAEdit .Inputs[De stination Input].Col umns[edita ction]" | |
184 | cachedCo depage="12 52" | |
185 | cachedDa taType="st r" | |
186 | cachedLe ngth="8000 " | |
187 | cachedNa me="editac tion" | |
188 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAEdit. Inputs[Des tination I nput].Exte rnalColumn s[EditActi on]" | |
189 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Output] .Columns[e ditaction] " /> | |
190 | <inputColu mn | |
191 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAEdit .Inputs[De stination Input].Col umns[editd ata]" | |
192 | cachedCo depage="12 52" | |
193 | cachedDa taType="st r" | |
194 | cachedLe ngth="8000 " | |
195 | cachedNa me="editda ta" | |
196 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAEdit. Inputs[Des tination I nput].Exte rnalColumn s[EditData ]" | |
197 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Output] .Columns[e ditdata]" /> | |
198 | <inputColu mn | |
199 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAEdit .Inputs[De stination Input].Col umns[overr iddenby]" | |
200 | cachedDa taType="i8 " | |
201 | cachedNa me="overri ddenby" | |
202 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAEdit. Inputs[Des tination I nput].Exte rnalColumn s[Overridd enBy]" | |
203 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Output] .Columns[o verriddenb y]" /> | |
204 | <inputColu mn | |
205 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAEdit .Inputs[De stination Input].Col umns[msgfr om]" | |
206 | cachedCo depage="12 52" | |
207 | cachedDa taType="st r" | |
208 | cachedLe ngth="10" | |
209 | cachedNa me="msgfro m" | |
210 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAEdit. Inputs[Des tination I nput].Exte rnalColumn s[MsgFrom] " | |
211 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Output] .Columns[m sgfrom]" / > | |
212 | <inputColu mn | |
213 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAEdit .Inputs[De stination Input].Col umns[threa d__id]" | |
214 | cachedDa taType="nu meric" | |
215 | cachedNa me="thread __id" | |
216 | cachedPr ecision="1 8" | |
217 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAEdit. Inputs[Des tination I nput].Exte rnalColumn s[Thread_I D]" | |
218 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Output] .Columns[t hread__id] " /> | |
219 | <inputColu mn | |
220 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAEdit .Inputs[De stination Input].Col umns[Batch LogID]" | |
221 | cachedDa taType="i8 " | |
222 | cachedNa me="BatchL ogID" | |
223 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAEdit. Inputs[Des tination I nput].Exte rnalColumn s[BatchLog ID]" | |
224 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Output] .Columns[B atchLogID] " /> | |
225 | </ inputColum ns> | |
226 | <e xternalMet adataColum ns | |
227 | isUsed="Tr ue"> | |
228 | <externalM etadataCol umn | |
229 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAEdit .Inputs[De stination Input].Ext ernalColum ns[Station Number]" | |
230 | codePage ="1252" | |
231 | dataType ="str" | |
232 | length=" 6" | |
233 | name="St ationNumbe r" /> | |
234 | <externalM etadataCol umn | |
235 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAEdit .Inputs[De stination Input].Ext ernalColum ns[HFCA_ID ]" | |
236 | dataType ="i8" | |
237 | name="HF CA_ID" /> | |
238 | <externalM etadataCol umn | |
239 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAEdit .Inputs[De stination Input].Ext ernalColum ns[Row_ID] " | |
240 | dataType ="i8" | |
241 | name="Ro w_ID" /> | |
242 | <externalM etadataCol umn | |
243 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAEdit .Inputs[De stination Input].Ext ernalColum ns[LineIte m]" | |
244 | dataType ="i8" | |
245 | name="Li neItem" /> | |
246 | <externalM etadataCol umn | |
247 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAEdit .Inputs[De stination Input].Ext ernalColum ns[EditCod e]" | |
248 | codePage ="1252" | |
249 | dataType ="str" | |
250 | length=" 4" | |
251 | name="Ed itCode" /> | |
252 | <externalM etadataCol umn | |
253 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAEdit .Inputs[De stination Input].Ext ernalColum ns[EditSub Code]" | |
254 | codePage ="1252" | |
255 | dataType ="str" | |
256 | length=" 2" | |
257 | name="Ed itSubCode" /> | |
258 | <externalM etadataCol umn | |
259 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAEdit .Inputs[De stination Input].Ext ernalColum ns[EditMsg ]" | |
260 | codePage ="1252" | |
261 | dataType ="str" | |
262 | length=" 4" | |
263 | name="Ed itMsg" /> | |
264 | <externalM etadataCol umn | |
265 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAEdit .Inputs[De stination Input].Ext ernalColum ns[EditAct ion]" | |
266 | codePage ="1252" | |
267 | dataType ="str" | |
268 | length=" 2" | |
269 | name="Ed itAction" /> | |
270 | <externalM etadataCol umn | |
271 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAEdit .Inputs[De stination Input].Ext ernalColum ns[EditDat a]" | |
272 | codePage ="1252" | |
273 | dataType ="str" | |
274 | length=" 12" | |
275 | name="Ed itData" /> | |
276 | <externalM etadataCol umn | |
277 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAEdit .Inputs[De stination Input].Ext ernalColum ns[Overrid denBy]" | |
278 | dataType ="i8" | |
279 | name="Ov erriddenBy " /> | |
280 | <externalM etadataCol umn | |
281 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAEdit .Inputs[De stination Input].Ext ernalColum ns[MsgFrom ]" | |
282 | codePage ="1252" | |
283 | dataType ="str" | |
284 | length=" 10" | |
285 | name="Ms gFrom" /> | |
286 | <externalM etadataCol umn | |
287 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAEdit .Inputs[De stination Input].Ext ernalColum ns[Thread_ ID]" | |
288 | dataType ="numeric" | |
289 | name="Th read_ID" | |
290 | precisio n="18" /> | |
291 | <externalM etadataCol umn | |
292 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAEdit .Inputs[De stination Input].Ext ernalColum ns[BatchLo gID]" | |
293 | dataType ="i8" | |
294 | name="Ba tchLogID" /> | |
295 | </ externalMe tadataColu mns> | |
296 | </in put> | |
297 | </inpu ts> | |
298 | <outpu ts> | |
299 | <out put | |
300 | re fId="Packa ge\Data Fl ow Task 1\ Destinatio n - FBCSHC FAEdit.Out puts[OLE D B Destinat ion Error Output]" | |
301 | ex clusionGro up="1" | |
302 | is ErrorOut=" true" | |
303 | na me="OLE DB Destinati on Error O utput" | |
304 | sy nchronousI nputId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAEdit. Inputs[Des tination I nput]"> | |
305 | <o utputColum ns> | |
306 | <outputCol umn | |
307 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAEdit .Outputs[O LE DB Dest ination Er ror Output ].Columns[ ErrorCode] " | |
308 | dataType ="i4" | |
309 | lineageI d="Package \Data Flow Task 1\De stination - FBCSHCFA Edit.Outpu ts[OLE DB Destinatio n Error Ou tput].Colu mns[ErrorC ode]" | |
310 | name="Er rorCode" | |
311 | specialF lags="1" / > | |
312 | <outputCol umn | |
313 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAEdit .Outputs[O LE DB Dest ination Er ror Output ].Columns[ ErrorColum n]" | |
314 | dataType ="i4" | |
315 | lineageI d="Package \Data Flow Task 1\De stination - FBCSHCFA Edit.Outpu ts[OLE DB Destinatio n Error Ou tput].Colu mns[ErrorC olumn]" | |
316 | name="Er rorColumn" | |
317 | specialF lags="2" / > | |
318 | </ outputColu mns> | |
319 | <e xternalMet adataColum ns /> | |
320 | </ou tput> | |
321 | </outp uts> | |
322 | </compon ent> | |
323 | <compone nt | |
324 | refId= "Package\D ata Flow T ask 1\Sour ce - _fbcs hcfaedit" | |
325 | compon entClassID ="Microsof t.OLEDBSou rce" | |
326 | contac tInfo="OLE DB Source ;Microsoft Corporati on; Micros oft SQL Se rver; (C) Microsoft Corporatio n; All Rig hts Reserv ed; http:/ /www.micro soft.com/s ql/support ;7" | |
327 | descri ption="OLE DB Source " | |
328 | name=" Source - _ fbcshcfaed it" | |
329 | usesDi spositions ="true" | |
330 | versio n="7"> | |
331 | <prope rties> | |
332 | <pro perty | |
333 | da taType="Sy stem.Int32 " | |
334 | de scription= "The numbe r of secon ds before a command times out. A value of 0 indic ates an in finite tim e-out." | |
335 | na me="Comman dTimeout"> 0</propert y> | |
336 | <pro perty | |
337 | da taType="Sy stem.Strin g" | |
338 | de scription= "Specifies the name of the dat abase obje ct used to open a ro wset." | |
339 | na me="OpenRo wset">[zra w].[_fbcsh cfaedit]</ property> | |
340 | <pro perty | |
341 | da taType="Sy stem.Strin g" | |
342 | de scription= "Specifies the varia ble that c ontains th e name of the databa se object used to op en a rowse t." | |
343 | na me="OpenRo wsetVariab le"></prop erty> | |
344 | <pro perty | |
345 | da taType="Sy stem.Strin g" | |
346 | de scription= "The SQL c ommand to be execute d." | |
347 | na me="SqlCom mand" | |
348 | UI TypeEditor ="Microsof t.DataTran sformation Services.C ontrols.Mo dalMultili neStringEd itor, Micr osoft.Data Transforma tionServic es.Control s, Version =14.0.0.0, Culture=n eutral, Pu blicKeyTok en=89845dc d8080cc91" ></propert y> | |
349 | <pro perty | |
350 | da taType="Sy stem.Strin g" | |
351 | de scription= "The varia ble that c ontains th e SQL comm and to be executed." | |
352 | na me="SqlCom mandVariab le"></prop erty> | |
353 | <pro perty | |
354 | da taType="Sy stem.Int32 " | |
355 | de scription= "Specifies the colum n code pag e to use w hen code p age inform ation is u navailable from the data sourc e." | |
356 | na me="Defaul tCodePage" >1252</pro perty> | |
357 | <pro perty | |
358 | da taType="Sy stem.Boole an" | |
359 | de scription= "Forces th e use of t he Default CodePage p roperty va lue when d escribing character data." | |
360 | na me="Always UseDefault CodePage"> false</pro perty> | |
361 | <pro perty | |
362 | da taType="Sy stem.Int32 " | |
363 | de scription= "Specifies the mode used to ac cess the d atabase." | |
364 | na me="Access Mode" | |
365 | ty peConverte r="AccessM ode">0</pr operty> | |
366 | <pro perty | |
367 | da taType="Sy stem.Strin g" | |
368 | de scription= "The mappi ngs betwee n the para meters in the SQL co mmand and variables. " | |
369 | na me="Parame terMapping "></proper ty> | |
370 | </prop erties> | |
371 | <conne ctions> | |
372 | <con nection | |
373 | re fId="Packa ge\Data Fl ow Task 1\ Source - _ fbcshcfaed it.Connect ions[OleDb Connection ]" | |
374 | co nnectionMa nagerID="P ackage.Con nectionMan agers[Sour ceConnecti onOLEDB]" | |
375 | co nnectionMa nagerRefId ="Package. Connection Managers[S ourceConne ctionOLEDB ]" | |
376 | de scription= "The OLE D B runtime connection used to a ccess the database." | |
377 | na me="OleDbC onnection" /> | |
378 | </conn ections> | |
379 | <outpu ts> | |
380 | <out put | |
381 | re fId="Packa ge\Data Fl ow Task 1\ Source - _ fbcshcfaed it.Outputs [OLE DB So urce Outpu t]" | |
382 | na me="OLE DB Source Ou tput"> | |
383 | <o utputColum ns> | |
384 | <outputCol umn | |
385 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source O utput].Col umns[stati on__no]" | |
386 | codePage ="1252" | |
387 | dataType ="str" | |
388 | errorOrT runcationO peration=" Conversion " | |
389 | errorRow Dispositio n="FailCom ponent" | |
390 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aedit.Outp uts[OLE DB Source Ou tput].Exte rnalColumn s[station_ _no]" | |
391 | length=" 30" | |
392 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Output] .Columns[s tation__no ]" | |
393 | name="st ation__no" | |
394 | truncati onRowDispo sition="Fa ilComponen t" /> | |
395 | <outputCol umn | |
396 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source O utput].Col umns[hcfai d]" | |
397 | dataType ="i8" | |
398 | errorOrT runcationO peration=" Conversion " | |
399 | errorRow Dispositio n="FailCom ponent" | |
400 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aedit.Outp uts[OLE DB Source Ou tput].Exte rnalColumn s[hcfaid]" | |
401 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Output] .Columns[h cfaid]" | |
402 | name="hc faid" | |
403 | truncati onRowDispo sition="Fa ilComponen t" /> | |
404 | <outputCol umn | |
405 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source O utput].Col umns[id]" | |
406 | dataType ="i8" | |
407 | errorOrT runcationO peration=" Conversion " | |
408 | errorRow Dispositio n="FailCom ponent" | |
409 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aedit.Outp uts[OLE DB Source Ou tput].Exte rnalColumn s[id]" | |
410 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Output] .Columns[i d]" | |
411 | name="id " | |
412 | truncati onRowDispo sition="Fa ilComponen t" /> | |
413 | <outputCol umn | |
414 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source O utput].Col umns[linei tem]" | |
415 | dataType ="i8" | |
416 | errorOrT runcationO peration=" Conversion " | |
417 | errorRow Dispositio n="FailCom ponent" | |
418 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aedit.Outp uts[OLE DB Source Ou tput].Exte rnalColumn s[lineitem ]" | |
419 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Output] .Columns[l ineitem]" | |
420 | name="li neitem" | |
421 | truncati onRowDispo sition="Fa ilComponen t" /> | |
422 | <outputCol umn | |
423 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source O utput].Col umns[editc ode]" | |
424 | codePage ="1252" | |
425 | dataType ="str" | |
426 | errorOrT runcationO peration=" Conversion " | |
427 | errorRow Dispositio n="FailCom ponent" | |
428 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aedit.Outp uts[OLE DB Source Ou tput].Exte rnalColumn s[editcode ]" | |
429 | length=" 8000" | |
430 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Output] .Columns[e ditcode]" | |
431 | name="ed itcode" | |
432 | truncati onRowDispo sition="Fa ilComponen t" /> | |
433 | <outputCol umn | |
434 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source O utput].Col umns[edits ubcode]" | |
435 | codePage ="1252" | |
436 | dataType ="str" | |
437 | errorOrT runcationO peration=" Conversion " | |
438 | errorRow Dispositio n="FailCom ponent" | |
439 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aedit.Outp uts[OLE DB Source Ou tput].Exte rnalColumn s[editsubc ode]" | |
440 | length=" 8000" | |
441 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Output] .Columns[e ditsubcode ]" | |
442 | name="ed itsubcode" | |
443 | truncati onRowDispo sition="Fa ilComponen t" /> | |
444 | <outputCol umn | |
445 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source O utput].Col umns[editm sg]" | |
446 | codePage ="1252" | |
447 | dataType ="str" | |
448 | errorOrT runcationO peration=" Conversion " | |
449 | errorRow Dispositio n="FailCom ponent" | |
450 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aedit.Outp uts[OLE DB Source Ou tput].Exte rnalColumn s[editmsg] " | |
451 | length=" 8000" | |
452 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Output] .Columns[e ditmsg]" | |
453 | name="ed itmsg" | |
454 | truncati onRowDispo sition="Fa ilComponen t" /> | |
455 | <outputCol umn | |
456 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source O utput].Col umns[edita ction]" | |
457 | codePage ="1252" | |
458 | dataType ="str" | |
459 | errorOrT runcationO peration=" Conversion " | |
460 | errorRow Dispositio n="FailCom ponent" | |
461 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aedit.Outp uts[OLE DB Source Ou tput].Exte rnalColumn s[editacti on]" | |
462 | length=" 8000" | |
463 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Output] .Columns[e ditaction] " | |
464 | name="ed itaction" | |
465 | truncati onRowDispo sition="Fa ilComponen t" /> | |
466 | <outputCol umn | |
467 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source O utput].Col umns[editd ata]" | |
468 | codePage ="1252" | |
469 | dataType ="str" | |
470 | errorOrT runcationO peration=" Conversion " | |
471 | errorRow Dispositio n="FailCom ponent" | |
472 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aedit.Outp uts[OLE DB Source Ou tput].Exte rnalColumn s[editdata ]" | |
473 | length=" 8000" | |
474 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Output] .Columns[e ditdata]" | |
475 | name="ed itdata" | |
476 | truncati onRowDispo sition="Fa ilComponen t" /> | |
477 | <outputCol umn | |
478 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source O utput].Col umns[overr iddenby]" | |
479 | dataType ="i8" | |
480 | errorOrT runcationO peration=" Conversion " | |
481 | errorRow Dispositio n="FailCom ponent" | |
482 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aedit.Outp uts[OLE DB Source Ou tput].Exte rnalColumn s[overridd enby]" | |
483 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Output] .Columns[o verriddenb y]" | |
484 | name="ov erriddenby " | |
485 | truncati onRowDispo sition="Fa ilComponen t" /> | |
486 | <outputCol umn | |
487 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source O utput].Col umns[msgfr om]" | |
488 | codePage ="1252" | |
489 | dataType ="str" | |
490 | errorOrT runcationO peration=" Conversion " | |
491 | errorRow Dispositio n="FailCom ponent" | |
492 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aedit.Outp uts[OLE DB Source Ou tput].Exte rnalColumn s[msgfrom] " | |
493 | length=" 10" | |
494 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Output] .Columns[m sgfrom]" | |
495 | name="ms gfrom" | |
496 | truncati onRowDispo sition="Fa ilComponen t" /> | |
497 | <outputCol umn | |
498 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source O utput].Col umns[threa d__id]" | |
499 | dataType ="numeric" | |
500 | errorOrT runcationO peration=" Conversion " | |
501 | errorRow Dispositio n="FailCom ponent" | |
502 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aedit.Outp uts[OLE DB Source Ou tput].Exte rnalColumn s[thread__ id]" | |
503 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Output] .Columns[t hread__id] " | |
504 | name="th read__id" | |
505 | precisio n="18" | |
506 | truncati onRowDispo sition="Fa ilComponen t" /> | |
507 | <outputCol umn | |
508 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source O utput].Col umns[Batch LogID]" | |
509 | dataType ="i8" | |
510 | errorOrT runcationO peration=" Conversion " | |
511 | errorRow Dispositio n="FailCom ponent" | |
512 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aedit.Outp uts[OLE DB Source Ou tput].Exte rnalColumn s[BatchLog ID]" | |
513 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Output] .Columns[B atchLogID] " | |
514 | name="Ba tchLogID" | |
515 | truncati onRowDispo sition="Fa ilComponen t" /> | |
516 | </ outputColu mns> | |
517 | <e xternalMet adataColum ns | |
518 | isUsed="Tr ue"> | |
519 | <externalM etadataCol umn | |
520 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source O utput].Ext ernalColum ns[station __no]" | |
521 | codePage ="1252" | |
522 | dataType ="str" | |
523 | length=" 30" | |
524 | name="st ation__no" /> | |
525 | <externalM etadataCol umn | |
526 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source O utput].Ext ernalColum ns[hcfaid] " | |
527 | dataType ="i8" | |
528 | name="hc faid" /> | |
529 | <externalM etadataCol umn | |
530 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source O utput].Ext ernalColum ns[id]" | |
531 | dataType ="i8" | |
532 | name="id " /> | |
533 | <externalM etadataCol umn | |
534 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source O utput].Ext ernalColum ns[lineite m]" | |
535 | dataType ="i8" | |
536 | name="li neitem" /> | |
537 | <externalM etadataCol umn | |
538 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source O utput].Ext ernalColum ns[editcod e]" | |
539 | codePage ="1252" | |
540 | dataType ="str" | |
541 | length=" 8000" | |
542 | name="ed itcode" /> | |
543 | <externalM etadataCol umn | |
544 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source O utput].Ext ernalColum ns[editsub code]" | |
545 | codePage ="1252" | |
546 | dataType ="str" | |
547 | length=" 8000" | |
548 | name="ed itsubcode" /> | |
549 | <externalM etadataCol umn | |
550 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source O utput].Ext ernalColum ns[editmsg ]" | |
551 | codePage ="1252" | |
552 | dataType ="str" | |
553 | length=" 8000" | |
554 | name="ed itmsg" /> | |
555 | <externalM etadataCol umn | |
556 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source O utput].Ext ernalColum ns[editact ion]" | |
557 | codePage ="1252" | |
558 | dataType ="str" | |
559 | length=" 8000" | |
560 | name="ed itaction" /> | |
561 | <externalM etadataCol umn | |
562 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source O utput].Ext ernalColum ns[editdat a]" | |
563 | codePage ="1252" | |
564 | dataType ="str" | |
565 | length=" 8000" | |
566 | name="ed itdata" /> | |
567 | <externalM etadataCol umn | |
568 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source O utput].Ext ernalColum ns[overrid denby]" | |
569 | dataType ="i8" | |
570 | name="ov erriddenby " /> | |
571 | <externalM etadataCol umn | |
572 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source O utput].Ext ernalColum ns[msgfrom ]" | |
573 | codePage ="1252" | |
574 | dataType ="str" | |
575 | length=" 10" | |
576 | name="ms gfrom" /> | |
577 | <externalM etadataCol umn | |
578 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source O utput].Ext ernalColum ns[thread_ _id]" | |
579 | dataType ="numeric" | |
580 | name="th read__id" | |
581 | precisio n="18" /> | |
582 | <externalM etadataCol umn | |
583 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source O utput].Ext ernalColum ns[BatchLo gID]" | |
584 | dataType ="i8" | |
585 | name="Ba tchLogID" /> | |
586 | </ externalMe tadataColu mns> | |
587 | </ou tput> | |
588 | <out put | |
589 | re fId="Packa ge\Data Fl ow Task 1\ Source - _ fbcshcfaed it.Outputs [OLE DB So urce Error Output]" | |
590 | is ErrorOut=" true" | |
591 | na me="OLE DB Source Er ror Output "> | |
592 | <o utputColum ns> | |
593 | <outputCol umn | |
594 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source E rror Outpu t].Columns [station__ no]" | |
595 | codePage ="1252" | |
596 | dataType ="str" | |
597 | length=" 30" | |
598 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Error O utput].Col umns[stati on__no]" | |
599 | name="st ation__no" /> | |
600 | <outputCol umn | |
601 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source E rror Outpu t].Columns [hcfaid]" | |
602 | dataType ="i8" | |
603 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Error O utput].Col umns[hcfai d]" | |
604 | name="hc faid" /> | |
605 | <outputCol umn | |
606 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source E rror Outpu t].Columns [id]" | |
607 | dataType ="i8" | |
608 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Error O utput].Col umns[id]" | |
609 | name="id " /> | |
610 | <outputCol umn | |
611 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source E rror Outpu t].Columns [lineitem] " | |
612 | dataType ="i8" | |
613 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Error O utput].Col umns[linei tem]" | |
614 | name="li neitem" /> | |
615 | <outputCol umn | |
616 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source E rror Outpu t].Columns [editcode] " | |
617 | codePage ="1252" | |
618 | dataType ="str" | |
619 | length=" 8000" | |
620 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Error O utput].Col umns[editc ode]" | |
621 | name="ed itcode" /> | |
622 | <outputCol umn | |
623 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source E rror Outpu t].Columns [editsubco de]" | |
624 | codePage ="1252" | |
625 | dataType ="str" | |
626 | length=" 8000" | |
627 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Error O utput].Col umns[edits ubcode]" | |
628 | name="ed itsubcode" /> | |
629 | <outputCol umn | |
630 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source E rror Outpu t].Columns [editmsg]" | |
631 | codePage ="1252" | |
632 | dataType ="str" | |
633 | length=" 8000" | |
634 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Error O utput].Col umns[editm sg]" | |
635 | name="ed itmsg" /> | |
636 | <outputCol umn | |
637 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source E rror Outpu t].Columns [editactio n]" | |
638 | codePage ="1252" | |
639 | dataType ="str" | |
640 | length=" 8000" | |
641 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Error O utput].Col umns[edita ction]" | |
642 | name="ed itaction" /> | |
643 | <outputCol umn | |
644 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source E rror Outpu t].Columns [editdata] " | |
645 | codePage ="1252" | |
646 | dataType ="str" | |
647 | length=" 8000" | |
648 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Error O utput].Col umns[editd ata]" | |
649 | name="ed itdata" /> | |
650 | <outputCol umn | |
651 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source E rror Outpu t].Columns [overridde nby]" | |
652 | dataType ="i8" | |
653 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Error O utput].Col umns[overr iddenby]" | |
654 | name="ov erriddenby " /> | |
655 | <outputCol umn | |
656 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source E rror Outpu t].Columns [msgfrom]" | |
657 | codePage ="1252" | |
658 | dataType ="str" | |
659 | length=" 10" | |
660 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Error O utput].Col umns[msgfr om]" | |
661 | name="ms gfrom" /> | |
662 | <outputCol umn | |
663 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source E rror Outpu t].Columns [thread__i d]" | |
664 | dataType ="numeric" | |
665 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Error O utput].Col umns[threa d__id]" | |
666 | name="th read__id" | |
667 | precisio n="18" /> | |
668 | <outputCol umn | |
669 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source E rror Outpu t].Columns [BatchLogI D]" | |
670 | dataType ="i8" | |
671 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Error O utput].Col umns[Batch LogID]" | |
672 | name="Ba tchLogID" /> | |
673 | <outputCol umn | |
674 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source E rror Outpu t].Columns [ErrorCode ]" | |
675 | dataType ="i4" | |
676 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Error O utput].Col umns[Error Code]" | |
677 | name="Er rorCode" | |
678 | specialF lags="1" / > | |
679 | <outputCol umn | |
680 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faedit.Out puts[OLE D B Source E rror Outpu t].Columns [ErrorColu mn]" | |
681 | dataType ="i4" | |
682 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Error O utput].Col umns[Error Column]" | |
683 | name="Er rorColumn" | |
684 | specialF lags="2" / > | |
685 | </ outputColu mns> | |
686 | <e xternalMet adataColum ns /> | |
687 | </ou tput> | |
688 | </outp uts> | |
689 | </compon ent> | |
690 | </componen ts> | |
691 | <paths> | |
692 | <path | |
693 | refId= "Package\D ata Flow T ask 1.Path s[OLE DB S ource Outp ut]" | |
694 | endId= "Package\D ata Flow T ask 1\Dest ination - FBCSHCFAEd it.Inputs[ Destinatio n Input]" | |
695 | name=" OLE DB Sou rce Output " | |
696 | startI d="Package \Data Flow Task 1\So urce - _fb cshcfaedit .Outputs[O LE DB Sour ce Output] " /> | |
697 | </paths> | |
698 | </ pipeline> | |
699 | </DT S:ObjectDa ta> | |
700 | </DTS: Executable > | |
701 | <DTS:E xecutable | |
702 | DTS: refId="Pac kage\Prepa ration SQL Task 1" | |
703 | DTS: CreationNa me="Micros oft.Execut eSQLTask" | |
704 | DTS: DTSID="{6E CBAC9B-443 5-4F6B-A64 B-C4E5AD0B 221D}" | |
705 | DTS: Executable Type="Micr osoft.Exec uteSQLTask " | |
706 | DTS: FailPackag eOnFailure ="True" | |
707 | DTS: LocaleID=" -1" | |
708 | DTS: ObjectName ="Preparat ion SQL Ta sk 1" | |
709 | DTS: TaskContac t="Execute SQL Task; Microsoft Corporati on; SQL Se rver 2017 RC1; © 201 7 Microsof t Corporat ion; All R ights Rese rved;http: //www.micr osoft.com/ sql/suppor t/default. asp;1" | |
710 | DTS: ThreadHint ="0"> | |
711 | <DTS :Variables /> | |
712 | <DTS :ObjectDat a> | |
713 | <S QLTask:Sql TaskData | |
714 | SQLTask:Co nnection=" {5BF9D14D- CDA1-400D- 882C-E1087 76A51C0}" | |
715 | SQLTask:Sq lStatement Source="CR EATE TABLE [CallCent er].[FBCSH CFAEdit] ( 
[Stat ionNumber] varchar(6 ) NOT NULL ,
[HFC A_ID] bigi nt,
[R ow_ID] big int,
[ LineItem] bigint,&#x A;[EditCod e] varchar (4),
[ EditSubCod e] varchar (2),
[ EditMsg] v archar(4), 
[Edit Action] va rchar(2),& #xA;[EditD ata] varch ar(12),&#x A;[Overrid denBy] big int,
[ MsgFrom] v archar(10) ,
[Thr ead_ID] nu meric(18,0 ) NOT NULL ,
[Bat chLogID] b igint
 )
GO&# xA;" xmlns :SQLTask=" www.micros oft.com/sq lserver/dt s/tasks/sq ltask" /> | |
716 | </DT S:ObjectDa ta> | |
717 | </DTS: Executable > | |
718 | </DTS:Ex ecutables> | |
719 | <DTS:Pre cedenceCon straints> | |
720 | <DTS:P recedenceC onstraint | |
721 | DTS: refId="Pac kage.Prece denceConst raints[{A7 53DBBE-A35 A-4706-9EF E-18C5984B 7277\}]" | |
722 | DTS: CreationNa me="" | |
723 | DTS: DTSID="{A7 53DBBE-A35 A-4706-9EF E-18C5984B 7277}" | |
724 | DTS: From="Pack age\Prepar ation SQL Task 1" | |
725 | DTS: LogicalAnd ="True" | |
726 | DTS: ObjectName ="{A753DBB E-A35A-470 6-9EFE-18C 5984B7277} " | |
727 | DTS: To="Packag e\Data Flo w Task 1" /> | |
728 | </DTS:Pr ecedenceCo nstraints> | |
729 | <DTS:Des ignTimePro perties><! [CDATA[<?x ml version ="1.0"?> | |
730 | <!--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.- -> | |
731 | <!--If you manually edit this section an d make a m istake, yo u can dele te it. --> | |
732 | <!--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.--> | |
733 | <Objects | |
734 | Version= "8"> | |
735 | <!--Each node belo w will con tain prope rties that do not af fect runti me behavio r.--> | |
736 | <Package | |
737 | design -time-name ="Package" > | |
738 | <Layou tInfo> | |
739 | <Gra phLayout | |
740 | 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 "> | |
741 | <N odeLayout | |
742 | Size="160, 42" | |
743 | Id="Packag e\Data Flo w Task 1" | |
744 | TopLeft="2 0.5,107.5" /> | |
745 | <N odeLayout | |
746 | Size="190, 42" | |
747 | Id="Packag e\Preparat ion SQL Ta sk 1" | |
748 | TopLeft="4 .500000000 00001,4.5" /> | |
749 | <E dgeLayout | |
750 | Id="Packag e.Preceden ceConstrai nts[{A753D BBE-A35A-4 706-9EFE-1 8C5984B727 7\}]" | |
751 | TopLeft="1 00,46.5"> | |
752 | <EdgeLayou t.Curve> | |
753 | <mssgle: Curve | |
754 | StartC onnector=" {assembly: Null}" | |
755 | EndCon nector="0, 61" | |
756 | Start= "0,0" | |
757 | End="0 ,53.5"> | |
758 | <mssgl e:Curve.Se gments> | |
759 | <mss gle:Segmen tCollectio n | |
760 | Ca pacity="5" > | |
761 | <m ssgle:Line Segment | |
762 | End="0,53. 5" /> | |
763 | </ms sgle:Segme ntCollecti on> | |
764 | </mssg le:Curve.S egments> | |
765 | </mssgle :Curve> | |
766 | </EdgeLayo ut.Curve> | |
767 | <EdgeLayou t.Labels> | |
768 | <EdgeLab elCollecti on /> | |
769 | </EdgeLayo ut.Labels> | |
770 | </ EdgeLayout > | |
771 | </Gr aphLayout> | |
772 | </Layo utInfo> | |
773 | </Packag e> | |
774 | <TaskHos t | |
775 | design -time-name ="Package\ Data Flow Task 1"> | |
776 | <Layou tInfo> | |
777 | <Gra phLayout | |
778 | 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 "> | |
779 | <N odeLayout | |
780 | Size="184, 42" | |
781 | Id="Packag e\Data Flo w Task 1\S ource - _f bcshcfaedi t" | |
782 | TopLeft="1 8.5,5.5" / > | |
783 | <N odeLayout | |
784 | Size="210, 42" | |
785 | Id="Packag e\Data Flo w Task 1\D estination - FBCSHCF AEdit" | |
786 | TopLeft="5 .500000000 00001,107. 5" /> | |
787 | <E dgeLayout | |
788 | Id="Packag e\Data Flo w Task 1.P aths[OLE D B Source O utput]" | |
789 | TopLeft="1 10.5,47.5" > | |
790 | <EdgeLayou t.Curve> | |
791 | <mssgle: Curve | |
792 | StartC onnector=" {assembly: Null}" | |
793 | EndCon nector="0, 60" | |
794 | Start= "0,0" | |
795 | End="0 ,52.5"> | |
796 | <mssgl e:Curve.Se gments> | |
797 | <mss gle:Segmen tCollectio n | |
798 | Ca pacity="5" > | |
799 | <m ssgle:Line Segment | |
800 | End="0,52. 5" /> | |
801 | </ms sgle:Segme ntCollecti on> | |
802 | </mssg le:Curve.S egments> | |
803 | </mssgle :Curve> | |
804 | </EdgeLayo ut.Curve> | |
805 | <EdgeLayou t.Labels> | |
806 | <EdgeLab elCollecti on /> | |
807 | </EdgeLayo ut.Labels> | |
808 | </ EdgeLayout > | |
809 | </Gr aphLayout> | |
810 | </Layo utInfo> | |
811 | </TaskHo st> | |
812 | </Objects> ]]></DTS:D esignTimeP roperties> | |
813 | </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.