Produced by Araxis Merge on 5/2/2019 1:18:55 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 CallCenter.FBCSHCFAClaimProviderInformation.dtsx | Thu Apr 18 16:53:26 2019 UTC |
2 | C:\AraxisMergeCompare\Pri_re\EPRS\EPRS_SSIS\EPRS.SSIS\EPRS.SSIS | Transfermation CallCenter.FBCSHCFAClaimProviderInformation.dtsx | Wed May 1 13:05:09 2019 UTC |
Description | Between Files 1 and 2 |
|
---|---|---|
Text Blocks | Lines | |
Unchanged | 4 | 3130 |
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=" 11/7/2017 1:09:25 PM " | |
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="{1C1939 78-8B70-4C F9-8D81-8B 8D5584DDA7 }" | |
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 CallCen ter FBCSHC FAClaimPro viderInfor mation" | |
15 | DTS:Vers ionBuild=" 1" | |
16 | DTS:Vers ionGUID="{ 93BEB804-C 79A-4C85-B 370-7B4FB3 FB6FFE}"> | |
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="{04 DC2365-7DD A-4269-B67 1-507D1C17 5E3F}" | |
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="{B2 AC5F6D-48B 4-4F49-BD2 1-F1D1C947 D721}" | |
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="{E5 D79720-2EC 4-45C7-A22 2-1E577323 6454}" | |
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 - FBCSHCFACl aimProvide rInformati on" | |
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 FAClaimPro viderInfor mation" | |
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].[ FBCSHCFACl aimProvide rInformati on]</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">fals e</propert y> | |
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 FAClaimPro viderInfor mation.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 FAClaimPro viderInfor mation.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 CSHCFAClai mProviderI nformation .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 SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Station_ Number]" | |
139 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[station __no]" /> | |
140 | <inputColu mn | |
141 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[id]" | |
142 | cachedDa taType="i8 " | |
143 | cachedNa me="id" | |
144 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[FBCSHFCA ClaimProvi derInforma tion_ID]" | |
145 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[id]" /> | |
146 | <inputColu mn | |
147 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[provi dername]" | |
148 | cachedCo depage="12 52" | |
149 | cachedDa taType="st r" | |
150 | cachedLe ngth="8000 " | |
151 | cachedNa me="provid ername" | |
152 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Provider _Name]" | |
153 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[provide rname]" /> | |
154 | <inputColu mn | |
155 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[a]" | |
156 | cachedDa taType="i4 " | |
157 | cachedNa me="a" | |
158 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Provider _Names_Occ urrences_w ith_A]" | |
159 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[a]" /> | |
160 | <inputColu mn | |
161 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[b]" | |
162 | cachedDa taType="i4 " | |
163 | cachedNa me="b" | |
164 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Provider _Names_Occ urrences_w ith_B]" | |
165 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[b]" /> | |
166 | <inputColu mn | |
167 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[c]" | |
168 | cachedDa taType="i4 " | |
169 | cachedNa me="c" | |
170 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Provider _Names_Occ urrences_w ith_C]" | |
171 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[c]" /> | |
172 | <inputColu mn | |
173 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[d]" | |
174 | cachedDa taType="i4 " | |
175 | cachedNa me="d" | |
176 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Provider _Names_Occ urrences_w ith_D]" | |
177 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[d]" /> | |
178 | <inputColu mn | |
179 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[e]" | |
180 | cachedDa taType="i4 " | |
181 | cachedNa me="e" | |
182 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Provider _Names_Occ urrences_w ith_E]" | |
183 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[e]" /> | |
184 | <inputColu mn | |
185 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[f]" | |
186 | cachedDa taType="i4 " | |
187 | cachedNa me="f" | |
188 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Provider _Names_Occ urrences_w ith_F]" | |
189 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[f]" /> | |
190 | <inputColu mn | |
191 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[g]" | |
192 | cachedDa taType="i4 " | |
193 | cachedNa me="g" | |
194 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Provider _Names_Occ urrences_w ith_G]" | |
195 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[g]" /> | |
196 | <inputColu mn | |
197 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[h]" | |
198 | cachedDa taType="i4 " | |
199 | cachedNa me="h" | |
200 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Provider _Names_Occ urrences_w ith_H]" | |
201 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[h]" /> | |
202 | <inputColu mn | |
203 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[i]" | |
204 | cachedDa taType="i4 " | |
205 | cachedNa me="i" | |
206 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[iProvide r_Names_Oc currences_ with_I]" | |
207 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[i]" /> | |
208 | <inputColu mn | |
209 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[j]" | |
210 | cachedDa taType="i4 " | |
211 | cachedNa me="j" | |
212 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Provider _Names_Occ urrences_w ith_J]" | |
213 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[j]" /> | |
214 | <inputColu mn | |
215 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[k]" | |
216 | cachedDa taType="i4 " | |
217 | cachedNa me="k" | |
218 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Provider _Names_Occ urrences_w ith_K]" | |
219 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[k]" /> | |
220 | <inputColu mn | |
221 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[l]" | |
222 | cachedDa taType="i4 " | |
223 | cachedNa me="l" | |
224 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Provider _Names_Occ urrences_w ith_L]" | |
225 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[l]" /> | |
226 | <inputColu mn | |
227 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[m]" | |
228 | cachedDa taType="i4 " | |
229 | cachedNa me="m" | |
230 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Provider _Names_Occ urrences_w ith_M]" | |
231 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[m]" /> | |
232 | <inputColu mn | |
233 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[n]" | |
234 | cachedDa taType="i4 " | |
235 | cachedNa me="n" | |
236 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Provider _Names_Occ urrences_w ith_N]" | |
237 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[n]" /> | |
238 | <inputColu mn | |
239 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[o]" | |
240 | cachedDa taType="i4 " | |
241 | cachedNa me="o" | |
242 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Provider _Names_Occ urrences_w ith_O]" | |
243 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[o]" /> | |
244 | <inputColu mn | |
245 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[p]" | |
246 | cachedDa taType="i4 " | |
247 | cachedNa me="p" | |
248 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Provider _Names_Occ urrences_w ith_P]" | |
249 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[p]" /> | |
250 | <inputColu mn | |
251 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[q]" | |
252 | cachedDa taType="i4 " | |
253 | cachedNa me="q" | |
254 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Provider _Names_Occ urrences_w ith_Q]" | |
255 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[q]" /> | |
256 | <inputColu mn | |
257 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[r]" | |
258 | cachedDa taType="i4 " | |
259 | cachedNa me="r" | |
260 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Provider _Names_Occ urrences_w ith_R]" | |
261 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[r]" /> | |
262 | <inputColu mn | |
263 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[s]" | |
264 | cachedDa taType="i4 " | |
265 | cachedNa me="s" | |
266 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Provider _Names_Occ urrences_w ith_S]" | |
267 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[s]" /> | |
268 | <inputColu mn | |
269 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[t]" | |
270 | cachedDa taType="i4 " | |
271 | cachedNa me="t" | |
272 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Provider _Names_Occ urrences_w ith_T]" | |
273 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[t]" /> | |
274 | <inputColu mn | |
275 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[u]" | |
276 | cachedDa taType="i4 " | |
277 | cachedNa me="u" | |
278 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Provider _Names_Occ urrences_w ith_U]" | |
279 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[u]" /> | |
280 | <inputColu mn | |
281 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[v]" | |
282 | cachedDa taType="i4 " | |
283 | cachedNa me="v" | |
284 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Provider _Names_Occ urrences_w ith_V]" | |
285 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[v]" /> | |
286 | <inputColu mn | |
287 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[w]" | |
288 | cachedDa taType="i4 " | |
289 | cachedNa me="w" | |
290 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Provider _Names_Occ urrences_w ith_W]" | |
291 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[w]" /> | |
292 | <inputColu mn | |
293 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[x]" | |
294 | cachedDa taType="i4 " | |
295 | cachedNa me="x" | |
296 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Provider _Names_Occ urrences_w ith_X]" | |
297 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[x]" /> | |
298 | <inputColu mn | |
299 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[y]" | |
300 | cachedDa taType="i4 " | |
301 | cachedNa me="y" | |
302 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Provider _Names_Occ urrences_w ith_Y]" | |
303 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[y]" /> | |
304 | <inputColu mn | |
305 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[z]" | |
306 | cachedDa taType="i4 " | |
307 | cachedNa me="z" | |
308 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Provider _Names_Occ urrences_w ith_Z]" | |
309 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[z]" /> | |
310 | <inputColu mn | |
311 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[total ]" | |
312 | cachedDa taType="i4 " | |
313 | cachedNa me="total" | |
314 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Total_Nu mber_of_Ch aracters_I nProviderN ame]" | |
315 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[total]" /> | |
316 | <inputColu mn | |
317 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[fspac e]" | |
318 | cachedDa taType="i4 " | |
319 | cachedNa me="fspace " | |
320 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Total_Nu mber_of_Sp aces_InPro viderName] " | |
321 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[fspace] " /> | |
322 | <inputColu mn | |
323 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[fdash ]" | |
324 | cachedDa taType="i4 " | |
325 | cachedNa me="fdash" | |
326 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Total_Nu mber_of_Da shes_InPro viderName] " | |
327 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[fdash]" /> | |
328 | <inputColu mn | |
329 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[fapos trophe]" | |
330 | cachedDa taType="i4 " | |
331 | cachedNa me="fapost rophe" | |
332 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Total_Nu mber_of_Ap ostrophes_ InProvider Name]" | |
333 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[fapostr ophe]" /> | |
334 | <inputColu mn | |
335 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[addre ss]" | |
336 | cachedCo depage="12 52" | |
337 | cachedDa taType="st r" | |
338 | cachedLe ngth="8000 " | |
339 | cachedNa me="addres s" | |
340 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Complete _Address]" | |
341 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[address ]" /> | |
342 | <inputColu mn | |
343 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[line1 ]" | |
344 | cachedCo depage="12 52" | |
345 | cachedDa taType="st r" | |
346 | cachedLe ngth="8000 " | |
347 | cachedNa me="line1" | |
348 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Address_ Line1]" | |
349 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[line1]" /> | |
350 | <inputColu mn | |
351 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[line2 ]" | |
352 | cachedCo depage="12 52" | |
353 | cachedDa taType="st r" | |
354 | cachedLe ngth="8000 " | |
355 | cachedNa me="line2" | |
356 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Address_ Line2]" | |
357 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[line2]" /> | |
358 | <inputColu mn | |
359 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[city] " | |
360 | cachedCo depage="12 52" | |
361 | cachedDa taType="st r" | |
362 | cachedLe ngth="8000 " | |
363 | cachedNa me="city" | |
364 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[City]" | |
365 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[city]" /> | |
366 | <inputColu mn | |
367 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[state ]" | |
368 | cachedCo depage="12 52" | |
369 | cachedDa taType="st r" | |
370 | cachedLe ngth="8000 " | |
371 | cachedNa me="state" | |
372 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[State]" | |
373 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[state]" /> | |
374 | <inputColu mn | |
375 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[zip]" | |
376 | cachedCo depage="12 52" | |
377 | cachedDa taType="st r" | |
378 | cachedLe ngth="8000 " | |
379 | cachedNa me="zip" | |
380 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Zip]" | |
381 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[zip]" / > | |
382 | <inputColu mn | |
383 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[threa d__id]" | |
384 | cachedDa taType="nu meric" | |
385 | cachedNa me="thread __id" | |
386 | cachedPr ecision="1 8" | |
387 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[Thread_I D]" | |
388 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[thread_ _id]" /> | |
389 | <inputColu mn | |
390 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Col umns[Batch LogID]" | |
391 | cachedDa taType="i8 " | |
392 | cachedNa me="BatchL ogID" | |
393 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput].Exte rnalColumn s[BatchLog _ID]" | |
394 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[BatchLo gID]" /> | |
395 | </ inputColum ns> | |
396 | <e xternalMet adataColum ns | |
397 | isUsed="Tr ue"> | |
398 | <externalM etadataCol umn | |
399 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Station _Number]" | |
400 | codePage ="1252" | |
401 | dataType ="str" | |
402 | length=" 30" | |
403 | name="St ation_Numb er" /> | |
404 | <externalM etadataCol umn | |
405 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[FBCSHFC AClaimProv iderInform ation_ID]" | |
406 | dataType ="i8" | |
407 | name="FB CSHFCAClai mProviderI nformation _ID" /> | |
408 | <externalM etadataCol umn | |
409 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Provide r_Name]" | |
410 | codePage ="1252" | |
411 | dataType ="str" | |
412 | length=" 8000" | |
413 | name="Pr ovider_Nam e" /> | |
414 | <externalM etadataCol umn | |
415 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Provide r_Names_Oc currences_ with_A]" | |
416 | dataType ="i4" | |
417 | name="Pr ovider_Nam es_Occurre nces_with_ A" /> | |
418 | <externalM etadataCol umn | |
419 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Provide r_Names_Oc currences_ with_B]" | |
420 | dataType ="i4" | |
421 | name="Pr ovider_Nam es_Occurre nces_with_ B" /> | |
422 | <externalM etadataCol umn | |
423 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Provide r_Names_Oc currences_ with_C]" | |
424 | dataType ="i4" | |
425 | name="Pr ovider_Nam es_Occurre nces_with_ C" /> | |
426 | <externalM etadataCol umn | |
427 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Provide r_Names_Oc currences_ with_D]" | |
428 | dataType ="i4" | |
429 | name="Pr ovider_Nam es_Occurre nces_with_ D" /> | |
430 | <externalM etadataCol umn | |
431 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Provide r_Names_Oc currences_ with_E]" | |
432 | dataType ="i4" | |
433 | name="Pr ovider_Nam es_Occurre nces_with_ E" /> | |
434 | <externalM etadataCol umn | |
435 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Provide r_Names_Oc currences_ with_F]" | |
436 | dataType ="i4" | |
437 | name="Pr ovider_Nam es_Occurre nces_with_ F" /> | |
438 | <externalM etadataCol umn | |
439 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Provide r_Names_Oc currences_ with_G]" | |
440 | dataType ="i4" | |
441 | name="Pr ovider_Nam es_Occurre nces_with_ G" /> | |
442 | <externalM etadataCol umn | |
443 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Provide r_Names_Oc currences_ with_H]" | |
444 | dataType ="i4" | |
445 | name="Pr ovider_Nam es_Occurre nces_with_ H" /> | |
446 | <externalM etadataCol umn | |
447 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[iProvid er_Names_O ccurrences _with_I]" | |
448 | dataType ="i4" | |
449 | name="iP rovider_Na mes_Occurr ences_with _I" /> | |
450 | <externalM etadataCol umn | |
451 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Provide r_Names_Oc currences_ with_J]" | |
452 | dataType ="i4" | |
453 | name="Pr ovider_Nam es_Occurre nces_with_ J" /> | |
454 | <externalM etadataCol umn | |
455 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Provide r_Names_Oc currences_ with_K]" | |
456 | dataType ="i4" | |
457 | name="Pr ovider_Nam es_Occurre nces_with_ K" /> | |
458 | <externalM etadataCol umn | |
459 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Provide r_Names_Oc currences_ with_L]" | |
460 | dataType ="i4" | |
461 | name="Pr ovider_Nam es_Occurre nces_with_ L" /> | |
462 | <externalM etadataCol umn | |
463 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Provide r_Names_Oc currences_ with_M]" | |
464 | dataType ="i4" | |
465 | name="Pr ovider_Nam es_Occurre nces_with_ M" /> | |
466 | <externalM etadataCol umn | |
467 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Provide r_Names_Oc currences_ with_N]" | |
468 | dataType ="i4" | |
469 | name="Pr ovider_Nam es_Occurre nces_with_ N" /> | |
470 | <externalM etadataCol umn | |
471 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Provide r_Names_Oc currences_ with_O]" | |
472 | dataType ="i4" | |
473 | name="Pr ovider_Nam es_Occurre nces_with_ O" /> | |
474 | <externalM etadataCol umn | |
475 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Provide r_Names_Oc currences_ with_P]" | |
476 | dataType ="i4" | |
477 | name="Pr ovider_Nam es_Occurre nces_with_ P" /> | |
478 | <externalM etadataCol umn | |
479 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Provide r_Names_Oc currences_ with_Q]" | |
480 | dataType ="i4" | |
481 | name="Pr ovider_Nam es_Occurre nces_with_ Q" /> | |
482 | <externalM etadataCol umn | |
483 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Provide r_Names_Oc currences_ with_R]" | |
484 | dataType ="i4" | |
485 | name="Pr ovider_Nam es_Occurre nces_with_ R" /> | |
486 | <externalM etadataCol umn | |
487 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Provide r_Names_Oc currences_ with_S]" | |
488 | dataType ="i4" | |
489 | name="Pr ovider_Nam es_Occurre nces_with_ S" /> | |
490 | <externalM etadataCol umn | |
491 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Provide r_Names_Oc currences_ with_T]" | |
492 | dataType ="i4" | |
493 | name="Pr ovider_Nam es_Occurre nces_with_ T" /> | |
494 | <externalM etadataCol umn | |
495 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Provide r_Names_Oc currences_ with_U]" | |
496 | dataType ="i4" | |
497 | name="Pr ovider_Nam es_Occurre nces_with_ U" /> | |
498 | <externalM etadataCol umn | |
499 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Provide r_Names_Oc currences_ with_V]" | |
500 | dataType ="i4" | |
501 | name="Pr ovider_Nam es_Occurre nces_with_ V" /> | |
502 | <externalM etadataCol umn | |
503 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Provide r_Names_Oc currences_ with_W]" | |
504 | dataType ="i4" | |
505 | name="Pr ovider_Nam es_Occurre nces_with_ W" /> | |
506 | <externalM etadataCol umn | |
507 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Provide r_Names_Oc currences_ with_X]" | |
508 | dataType ="i4" | |
509 | name="Pr ovider_Nam es_Occurre nces_with_ X" /> | |
510 | <externalM etadataCol umn | |
511 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Provide r_Names_Oc currences_ with_Y]" | |
512 | dataType ="i4" | |
513 | name="Pr ovider_Nam es_Occurre nces_with_ Y" /> | |
514 | <externalM etadataCol umn | |
515 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Provide r_Names_Oc currences_ with_Z]" | |
516 | dataType ="i4" | |
517 | name="Pr ovider_Nam es_Occurre nces_with_ Z" /> | |
518 | <externalM etadataCol umn | |
519 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Total_N umber_of_C haracters_ InProvider Name]" | |
520 | dataType ="i4" | |
521 | name="To tal_Number _of_Charac ters_InPro viderName" /> | |
522 | <externalM etadataCol umn | |
523 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Total_N umber_of_S paces_InPr oviderName ]" | |
524 | dataType ="i4" | |
525 | name="To tal_Number _of_Spaces _InProvide rName" /> | |
526 | <externalM etadataCol umn | |
527 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Total_N umber_of_D ashes_InPr oviderName ]" | |
528 | dataType ="i4" | |
529 | name="To tal_Number _of_Dashes _InProvide rName" /> | |
530 | <externalM etadataCol umn | |
531 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Total_N umber_of_A postrophes _InProvide rName]" | |
532 | dataType ="i4" | |
533 | name="To tal_Number _of_Apostr ophes_InPr oviderName " /> | |
534 | <externalM etadataCol umn | |
535 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Complet e_Address] " | |
536 | codePage ="1252" | |
537 | dataType ="str" | |
538 | length=" 8000" | |
539 | name="Co mplete_Add ress" /> | |
540 | <externalM etadataCol umn | |
541 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Address _Line1]" | |
542 | codePage ="1252" | |
543 | dataType ="str" | |
544 | length=" 8000" | |
545 | name="Ad dress_Line 1" /> | |
546 | <externalM etadataCol umn | |
547 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Address _Line2]" | |
548 | codePage ="1252" | |
549 | dataType ="str" | |
550 | length=" 8000" | |
551 | name="Ad dress_Line 2" /> | |
552 | <externalM etadataCol umn | |
553 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[City]" | |
554 | codePage ="1252" | |
555 | dataType ="str" | |
556 | length=" 8000" | |
557 | name="Ci ty" /> | |
558 | <externalM etadataCol umn | |
559 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[State]" | |
560 | codePage ="1252" | |
561 | dataType ="str" | |
562 | length=" 8000" | |
563 | name="St ate" /> | |
564 | <externalM etadataCol umn | |
565 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Zip]" | |
566 | codePage ="1252" | |
567 | dataType ="str" | |
568 | length=" 8000" | |
569 | name="Zi p" /> | |
570 | <externalM etadataCol umn | |
571 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[Thread_ ID]" | |
572 | dataType ="numeric" | |
573 | name="Th read_ID" | |
574 | precisio n="18" /> | |
575 | <externalM etadataCol umn | |
576 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Inputs[De stination Input].Ext ernalColum ns[BatchLo g_ID]" | |
577 | dataType ="i8" | |
578 | name="Ba tchLog_ID" /> | |
579 | </ externalMe tadataColu mns> | |
580 | </in put> | |
581 | </inpu ts> | |
582 | <outpu ts> | |
583 | <out put | |
584 | re fId="Packa ge\Data Fl ow Task 1\ Destinatio n - FBCSHC FAClaimPro viderInfor mation.Out puts[OLE D B Destinat ion Error Output]" | |
585 | ex clusionGro up="1" | |
586 | is ErrorOut=" true" | |
587 | na me="OLE DB Destinati on Error O utput" | |
588 | sy nchronousI nputId="Pa ckage\Data Flow Task 1\Destina tion - FBC SHCFAClaim ProviderIn formation. Inputs[Des tination I nput]"> | |
589 | <o utputColum ns> | |
590 | <outputCol umn | |
591 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Outputs[O LE DB Dest ination Er ror Output ].Columns[ ErrorCode] " | |
592 | dataType ="i4" | |
593 | lineageI d="Package \Data Flow Task 1\De stination - FBCSHCFA ClaimProvi derInforma tion.Outpu ts[OLE DB Destinatio n Error Ou tput].Colu mns[ErrorC ode]" | |
594 | name="Er rorCode" | |
595 | specialF lags="1" / > | |
596 | <outputCol umn | |
597 | refId="P ackage\Dat a Flow Tas k 1\Destin ation - FB CSHCFAClai mProviderI nformation .Outputs[O LE DB Dest ination Er ror Output ].Columns[ ErrorColum n]" | |
598 | dataType ="i4" | |
599 | lineageI d="Package \Data Flow Task 1\De stination - FBCSHCFA ClaimProvi derInforma tion.Outpu ts[OLE DB Destinatio n Error Ou tput].Colu mns[ErrorC olumn]" | |
600 | name="Er rorColumn" | |
601 | specialF lags="2" / > | |
602 | </ outputColu mns> | |
603 | <e xternalMet adataColum ns /> | |
604 | </ou tput> | |
605 | </outp uts> | |
606 | </compon ent> | |
607 | <compone nt | |
608 | refId= "Package\D ata Flow T ask 1\Sour ce - _fbcs hcfaprovid er" | |
609 | compon entClassID ="Microsof t.OLEDBSou rce" | |
610 | 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" | |
611 | descri ption="OLE DB Source " | |
612 | name=" Source - _ fbcshcfapr ovider" | |
613 | usesDi spositions ="true" | |
614 | versio n="7"> | |
615 | <prope rties> | |
616 | <pro perty | |
617 | da taType="Sy stem.Int32 " | |
618 | 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." | |
619 | na me="Comman dTimeout"> 0</propert y> | |
620 | <pro perty | |
621 | da taType="Sy stem.Strin g" | |
622 | de scription= "Specifies the name of the dat abase obje ct used to open a ro wset." | |
623 | na me="OpenRo wset">[zra w].[_fbcsh cfaprovide r]</proper ty> | |
624 | <pro perty | |
625 | da taType="Sy stem.Strin g" | |
626 | de scription= "Specifies the varia ble that c ontains th e name of the databa se object used to op en a rowse t." | |
627 | na me="OpenRo wsetVariab le"></prop erty> | |
628 | <pro perty | |
629 | da taType="Sy stem.Strin g" | |
630 | de scription= "The SQL c ommand to be execute d." | |
631 | na me="SqlCom mand" | |
632 | 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> | |
633 | <pro perty | |
634 | da taType="Sy stem.Strin g" | |
635 | de scription= "The varia ble that c ontains th e SQL comm and to be executed." | |
636 | na me="SqlCom mandVariab le"></prop erty> | |
637 | <pro perty | |
638 | da taType="Sy stem.Int32 " | |
639 | 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." | |
640 | na me="Defaul tCodePage" >1252</pro perty> | |
641 | <pro perty | |
642 | da taType="Sy stem.Boole an" | |
643 | de scription= "Forces th e use of t he Default CodePage p roperty va lue when d escribing character data." | |
644 | na me="Always UseDefault CodePage"> false</pro perty> | |
645 | <pro perty | |
646 | da taType="Sy stem.Int32 " | |
647 | de scription= "Specifies the mode used to ac cess the d atabase." | |
648 | na me="Access Mode" | |
649 | ty peConverte r="AccessM ode">0</pr operty> | |
650 | <pro perty | |
651 | da taType="Sy stem.Strin g" | |
652 | de scription= "The mappi ngs betwee n the para meters in the SQL co mmand and variables. " | |
653 | na me="Parame terMapping "></proper ty> | |
654 | </prop erties> | |
655 | <conne ctions> | |
656 | <con nection | |
657 | re fId="Packa ge\Data Fl ow Task 1\ Source - _ fbcshcfapr ovider.Con nections[O leDbConnec tion]" | |
658 | co nnectionMa nagerID="P ackage.Con nectionMan agers[Sour ceConnecti onOLEDB]" | |
659 | co nnectionMa nagerRefId ="Package. Connection Managers[S ourceConne ctionOLEDB ]" | |
660 | de scription= "The OLE D B runtime connection used to a ccess the database." | |
661 | na me="OleDbC onnection" /> | |
662 | </conn ections> | |
663 | <outpu ts> | |
664 | <out put | |
665 | re fId="Packa ge\Data Fl ow Task 1\ Source - _ fbcshcfapr ovider.Out puts[OLE D B Source O utput]" | |
666 | na me="OLE DB Source Ou tput"> | |
667 | <o utputColum ns> | |
668 | <outputCol umn | |
669 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[s tation__no ]" | |
670 | codePage ="1252" | |
671 | dataType ="str" | |
672 | errorOrT runcationO peration=" Conversion " | |
673 | errorRow Dispositio n="FailCom ponent" | |
674 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[stat ion__no]" | |
675 | length=" 30" | |
676 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[station __no]" | |
677 | name="st ation__no" | |
678 | truncati onRowDispo sition="Fa ilComponen t" /> | |
679 | <outputCol umn | |
680 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[i d]" | |
681 | dataType ="i8" | |
682 | errorOrT runcationO peration=" Conversion " | |
683 | errorRow Dispositio n="FailCom ponent" | |
684 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[id]" | |
685 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[id]" | |
686 | name="id " | |
687 | truncati onRowDispo sition="Fa ilComponen t" /> | |
688 | <outputCol umn | |
689 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[p rovidernam e]" | |
690 | codePage ="1252" | |
691 | dataType ="str" | |
692 | errorOrT runcationO peration=" Conversion " | |
693 | errorRow Dispositio n="FailCom ponent" | |
694 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[prov idername]" | |
695 | length=" 8000" | |
696 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[provide rname]" | |
697 | name="pr ovidername " | |
698 | truncati onRowDispo sition="Fa ilComponen t" /> | |
699 | <outputCol umn | |
700 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[a ]" | |
701 | dataType ="i4" | |
702 | errorOrT runcationO peration=" Conversion " | |
703 | errorRow Dispositio n="FailCom ponent" | |
704 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[a]" | |
705 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[a]" | |
706 | name="a" | |
707 | truncati onRowDispo sition="Fa ilComponen t" /> | |
708 | <outputCol umn | |
709 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[b ]" | |
710 | dataType ="i4" | |
711 | errorOrT runcationO peration=" Conversion " | |
712 | errorRow Dispositio n="FailCom ponent" | |
713 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[b]" | |
714 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[b]" | |
715 | name="b" | |
716 | truncati onRowDispo sition="Fa ilComponen t" /> | |
717 | <outputCol umn | |
718 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[c ]" | |
719 | dataType ="i4" | |
720 | errorOrT runcationO peration=" Conversion " | |
721 | errorRow Dispositio n="FailCom ponent" | |
722 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[c]" | |
723 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[c]" | |
724 | name="c" | |
725 | truncati onRowDispo sition="Fa ilComponen t" /> | |
726 | <outputCol umn | |
727 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[d ]" | |
728 | dataType ="i4" | |
729 | errorOrT runcationO peration=" Conversion " | |
730 | errorRow Dispositio n="FailCom ponent" | |
731 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[d]" | |
732 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[d]" | |
733 | name="d" | |
734 | truncati onRowDispo sition="Fa ilComponen t" /> | |
735 | <outputCol umn | |
736 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[e ]" | |
737 | dataType ="i4" | |
738 | errorOrT runcationO peration=" Conversion " | |
739 | errorRow Dispositio n="FailCom ponent" | |
740 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[e]" | |
741 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[e]" | |
742 | name="e" | |
743 | truncati onRowDispo sition="Fa ilComponen t" /> | |
744 | <outputCol umn | |
745 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[f ]" | |
746 | dataType ="i4" | |
747 | errorOrT runcationO peration=" Conversion " | |
748 | errorRow Dispositio n="FailCom ponent" | |
749 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[f]" | |
750 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[f]" | |
751 | name="f" | |
752 | truncati onRowDispo sition="Fa ilComponen t" /> | |
753 | <outputCol umn | |
754 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[g ]" | |
755 | dataType ="i4" | |
756 | errorOrT runcationO peration=" Conversion " | |
757 | errorRow Dispositio n="FailCom ponent" | |
758 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[g]" | |
759 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[g]" | |
760 | name="g" | |
761 | truncati onRowDispo sition="Fa ilComponen t" /> | |
762 | <outputCol umn | |
763 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[h ]" | |
764 | dataType ="i4" | |
765 | errorOrT runcationO peration=" Conversion " | |
766 | errorRow Dispositio n="FailCom ponent" | |
767 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[h]" | |
768 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[h]" | |
769 | name="h" | |
770 | truncati onRowDispo sition="Fa ilComponen t" /> | |
771 | <outputCol umn | |
772 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[i ]" | |
773 | dataType ="i4" | |
774 | errorOrT runcationO peration=" Conversion " | |
775 | errorRow Dispositio n="FailCom ponent" | |
776 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[i]" | |
777 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[i]" | |
778 | name="i" | |
779 | truncati onRowDispo sition="Fa ilComponen t" /> | |
780 | <outputCol umn | |
781 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[j ]" | |
782 | dataType ="i4" | |
783 | errorOrT runcationO peration=" Conversion " | |
784 | errorRow Dispositio n="FailCom ponent" | |
785 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[j]" | |
786 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[j]" | |
787 | name="j" | |
788 | truncati onRowDispo sition="Fa ilComponen t" /> | |
789 | <outputCol umn | |
790 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[k ]" | |
791 | dataType ="i4" | |
792 | errorOrT runcationO peration=" Conversion " | |
793 | errorRow Dispositio n="FailCom ponent" | |
794 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[k]" | |
795 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[k]" | |
796 | name="k" | |
797 | truncati onRowDispo sition="Fa ilComponen t" /> | |
798 | <outputCol umn | |
799 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[l ]" | |
800 | dataType ="i4" | |
801 | errorOrT runcationO peration=" Conversion " | |
802 | errorRow Dispositio n="FailCom ponent" | |
803 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[l]" | |
804 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[l]" | |
805 | name="l" | |
806 | truncati onRowDispo sition="Fa ilComponen t" /> | |
807 | <outputCol umn | |
808 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[m ]" | |
809 | dataType ="i4" | |
810 | errorOrT runcationO peration=" Conversion " | |
811 | errorRow Dispositio n="FailCom ponent" | |
812 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[m]" | |
813 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[m]" | |
814 | name="m" | |
815 | truncati onRowDispo sition="Fa ilComponen t" /> | |
816 | <outputCol umn | |
817 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[n ]" | |
818 | dataType ="i4" | |
819 | errorOrT runcationO peration=" Conversion " | |
820 | errorRow Dispositio n="FailCom ponent" | |
821 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[n]" | |
822 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[n]" | |
823 | name="n" | |
824 | truncati onRowDispo sition="Fa ilComponen t" /> | |
825 | <outputCol umn | |
826 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[o ]" | |
827 | dataType ="i4" | |
828 | errorOrT runcationO peration=" Conversion " | |
829 | errorRow Dispositio n="FailCom ponent" | |
830 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[o]" | |
831 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[o]" | |
832 | name="o" | |
833 | truncati onRowDispo sition="Fa ilComponen t" /> | |
834 | <outputCol umn | |
835 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[p ]" | |
836 | dataType ="i4" | |
837 | errorOrT runcationO peration=" Conversion " | |
838 | errorRow Dispositio n="FailCom ponent" | |
839 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[p]" | |
840 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[p]" | |
841 | name="p" | |
842 | truncati onRowDispo sition="Fa ilComponen t" /> | |
843 | <outputCol umn | |
844 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[q ]" | |
845 | dataType ="i4" | |
846 | errorOrT runcationO peration=" Conversion " | |
847 | errorRow Dispositio n="FailCom ponent" | |
848 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[q]" | |
849 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[q]" | |
850 | name="q" | |
851 | truncati onRowDispo sition="Fa ilComponen t" /> | |
852 | <outputCol umn | |
853 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[r ]" | |
854 | dataType ="i4" | |
855 | errorOrT runcationO peration=" Conversion " | |
856 | errorRow Dispositio n="FailCom ponent" | |
857 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[r]" | |
858 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[r]" | |
859 | name="r" | |
860 | truncati onRowDispo sition="Fa ilComponen t" /> | |
861 | <outputCol umn | |
862 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[s ]" | |
863 | dataType ="i4" | |
864 | errorOrT runcationO peration=" Conversion " | |
865 | errorRow Dispositio n="FailCom ponent" | |
866 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[s]" | |
867 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[s]" | |
868 | name="s" | |
869 | truncati onRowDispo sition="Fa ilComponen t" /> | |
870 | <outputCol umn | |
871 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[t ]" | |
872 | dataType ="i4" | |
873 | errorOrT runcationO peration=" Conversion " | |
874 | errorRow Dispositio n="FailCom ponent" | |
875 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[t]" | |
876 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[t]" | |
877 | name="t" | |
878 | truncati onRowDispo sition="Fa ilComponen t" /> | |
879 | <outputCol umn | |
880 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[u ]" | |
881 | dataType ="i4" | |
882 | errorOrT runcationO peration=" Conversion " | |
883 | errorRow Dispositio n="FailCom ponent" | |
884 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[u]" | |
885 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[u]" | |
886 | name="u" | |
887 | truncati onRowDispo sition="Fa ilComponen t" /> | |
888 | <outputCol umn | |
889 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[v ]" | |
890 | dataType ="i4" | |
891 | errorOrT runcationO peration=" Conversion " | |
892 | errorRow Dispositio n="FailCom ponent" | |
893 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[v]" | |
894 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[v]" | |
895 | name="v" | |
896 | truncati onRowDispo sition="Fa ilComponen t" /> | |
897 | <outputCol umn | |
898 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[w ]" | |
899 | dataType ="i4" | |
900 | errorOrT runcationO peration=" Conversion " | |
901 | errorRow Dispositio n="FailCom ponent" | |
902 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[w]" | |
903 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[w]" | |
904 | name="w" | |
905 | truncati onRowDispo sition="Fa ilComponen t" /> | |
906 | <outputCol umn | |
907 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[x ]" | |
908 | dataType ="i4" | |
909 | errorOrT runcationO peration=" Conversion " | |
910 | errorRow Dispositio n="FailCom ponent" | |
911 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[x]" | |
912 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[x]" | |
913 | name="x" | |
914 | truncati onRowDispo sition="Fa ilComponen t" /> | |
915 | <outputCol umn | |
916 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[y ]" | |
917 | dataType ="i4" | |
918 | errorOrT runcationO peration=" Conversion " | |
919 | errorRow Dispositio n="FailCom ponent" | |
920 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[y]" | |
921 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[y]" | |
922 | name="y" | |
923 | truncati onRowDispo sition="Fa ilComponen t" /> | |
924 | <outputCol umn | |
925 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[z ]" | |
926 | dataType ="i4" | |
927 | errorOrT runcationO peration=" Conversion " | |
928 | errorRow Dispositio n="FailCom ponent" | |
929 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[z]" | |
930 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[z]" | |
931 | name="z" | |
932 | truncati onRowDispo sition="Fa ilComponen t" /> | |
933 | <outputCol umn | |
934 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[t otal]" | |
935 | dataType ="i4" | |
936 | errorOrT runcationO peration=" Conversion " | |
937 | errorRow Dispositio n="FailCom ponent" | |
938 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[tota l]" | |
939 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[total]" | |
940 | name="to tal" | |
941 | truncati onRowDispo sition="Fa ilComponen t" /> | |
942 | <outputCol umn | |
943 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[f space]" | |
944 | dataType ="i4" | |
945 | errorOrT runcationO peration=" Conversion " | |
946 | errorRow Dispositio n="FailCom ponent" | |
947 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[fspa ce]" | |
948 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[fspace] " | |
949 | name="fs pace" | |
950 | truncati onRowDispo sition="Fa ilComponen t" /> | |
951 | <outputCol umn | |
952 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[f dash]" | |
953 | dataType ="i4" | |
954 | errorOrT runcationO peration=" Conversion " | |
955 | errorRow Dispositio n="FailCom ponent" | |
956 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[fdas h]" | |
957 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[fdash]" | |
958 | name="fd ash" | |
959 | truncati onRowDispo sition="Fa ilComponen t" /> | |
960 | <outputCol umn | |
961 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[f apostrophe ]" | |
962 | dataType ="i4" | |
963 | errorOrT runcationO peration=" Conversion " | |
964 | errorRow Dispositio n="FailCom ponent" | |
965 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[fapo strophe]" | |
966 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[fapostr ophe]" | |
967 | name="fa postrophe" | |
968 | truncati onRowDispo sition="Fa ilComponen t" /> | |
969 | <outputCol umn | |
970 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[a ddress]" | |
971 | codePage ="1252" | |
972 | dataType ="str" | |
973 | errorOrT runcationO peration=" Conversion " | |
974 | errorRow Dispositio n="FailCom ponent" | |
975 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[addr ess]" | |
976 | length=" 8000" | |
977 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[address ]" | |
978 | name="ad dress" | |
979 | truncati onRowDispo sition="Fa ilComponen t" /> | |
980 | <outputCol umn | |
981 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[l ine1]" | |
982 | codePage ="1252" | |
983 | dataType ="str" | |
984 | errorOrT runcationO peration=" Conversion " | |
985 | errorRow Dispositio n="FailCom ponent" | |
986 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[line 1]" | |
987 | length=" 8000" | |
988 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[line1]" | |
989 | name="li ne1" | |
990 | truncati onRowDispo sition="Fa ilComponen t" /> | |
991 | <outputCol umn | |
992 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[l ine2]" | |
993 | codePage ="1252" | |
994 | dataType ="str" | |
995 | errorOrT runcationO peration=" Conversion " | |
996 | errorRow Dispositio n="FailCom ponent" | |
997 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[line 2]" | |
998 | length=" 8000" | |
999 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[line2]" | |
1000 | name="li ne2" | |
1001 | truncati onRowDispo sition="Fa ilComponen t" /> | |
1002 | <outputCol umn | |
1003 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[c ity]" | |
1004 | codePage ="1252" | |
1005 | dataType ="str" | |
1006 | errorOrT runcationO peration=" Conversion " | |
1007 | errorRow Dispositio n="FailCom ponent" | |
1008 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[city ]" | |
1009 | length=" 8000" | |
1010 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[city]" | |
1011 | name="ci ty" | |
1012 | truncati onRowDispo sition="Fa ilComponen t" /> | |
1013 | <outputCol umn | |
1014 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[s tate]" | |
1015 | codePage ="1252" | |
1016 | dataType ="str" | |
1017 | errorOrT runcationO peration=" Conversion " | |
1018 | errorRow Dispositio n="FailCom ponent" | |
1019 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[stat e]" | |
1020 | length=" 8000" | |
1021 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[state]" | |
1022 | name="st ate" | |
1023 | truncati onRowDispo sition="Fa ilComponen t" /> | |
1024 | <outputCol umn | |
1025 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[z ip]" | |
1026 | codePage ="1252" | |
1027 | dataType ="str" | |
1028 | errorOrT runcationO peration=" Conversion " | |
1029 | errorRow Dispositio n="FailCom ponent" | |
1030 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[zip] " | |
1031 | length=" 8000" | |
1032 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[zip]" | |
1033 | name="zi p" | |
1034 | truncati onRowDispo sition="Fa ilComponen t" /> | |
1035 | <outputCol umn | |
1036 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[t hread__id] " | |
1037 | dataType ="numeric" | |
1038 | errorOrT runcationO peration=" Conversion " | |
1039 | errorRow Dispositio n="FailCom ponent" | |
1040 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[thre ad__id]" | |
1041 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[thread_ _id]" | |
1042 | name="th read__id" | |
1043 | precisio n="18" | |
1044 | truncati onRowDispo sition="Fa ilComponen t" /> | |
1045 | <outputCol umn | |
1046 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .Columns[B atchLogID] " | |
1047 | dataType ="i8" | |
1048 | errorOrT runcationO peration=" Conversion " | |
1049 | errorRow Dispositio n="FailCom ponent" | |
1050 | external MetadataCo lumnId="Pa ckage\Data Flow Task 1\Source - _fbcshcf aprovider. Outputs[OL E DB Sourc e Output]. ExternalCo lumns[Batc hLogID]" | |
1051 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put].Colum ns[BatchLo gID]" | |
1052 | name="Ba tchLogID" | |
1053 | truncati onRowDispo sition="Fa ilComponen t" /> | |
1054 | </ outputColu mns> | |
1055 | <e xternalMet adataColum ns | |
1056 | isUsed="Tr ue"> | |
1057 | <externalM etadataCol umn | |
1058 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[sta tion__no]" | |
1059 | codePage ="1252" | |
1060 | dataType ="str" | |
1061 | length=" 30" | |
1062 | name="st ation__no" /> | |
1063 | <externalM etadataCol umn | |
1064 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[id] " | |
1065 | dataType ="i8" | |
1066 | name="id " /> | |
1067 | <externalM etadataCol umn | |
1068 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[pro vidername] " | |
1069 | codePage ="1252" | |
1070 | dataType ="str" | |
1071 | length=" 8000" | |
1072 | name="pr ovidername " /> | |
1073 | <externalM etadataCol umn | |
1074 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[a]" | |
1075 | dataType ="i4" | |
1076 | name="a" /> | |
1077 | <externalM etadataCol umn | |
1078 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[b]" | |
1079 | dataType ="i4" | |
1080 | name="b" /> | |
1081 | <externalM etadataCol umn | |
1082 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[c]" | |
1083 | dataType ="i4" | |
1084 | name="c" /> | |
1085 | <externalM etadataCol umn | |
1086 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[d]" | |
1087 | dataType ="i4" | |
1088 | name="d" /> | |
1089 | <externalM etadataCol umn | |
1090 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[e]" | |
1091 | dataType ="i4" | |
1092 | name="e" /> | |
1093 | <externalM etadataCol umn | |
1094 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[f]" | |
1095 | dataType ="i4" | |
1096 | name="f" /> | |
1097 | <externalM etadataCol umn | |
1098 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[g]" | |
1099 | dataType ="i4" | |
1100 | name="g" /> | |
1101 | <externalM etadataCol umn | |
1102 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[h]" | |
1103 | dataType ="i4" | |
1104 | name="h" /> | |
1105 | <externalM etadataCol umn | |
1106 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[i]" | |
1107 | dataType ="i4" | |
1108 | name="i" /> | |
1109 | <externalM etadataCol umn | |
1110 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[j]" | |
1111 | dataType ="i4" | |
1112 | name="j" /> | |
1113 | <externalM etadataCol umn | |
1114 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[k]" | |
1115 | dataType ="i4" | |
1116 | name="k" /> | |
1117 | <externalM etadataCol umn | |
1118 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[l]" | |
1119 | dataType ="i4" | |
1120 | name="l" /> | |
1121 | <externalM etadataCol umn | |
1122 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[m]" | |
1123 | dataType ="i4" | |
1124 | name="m" /> | |
1125 | <externalM etadataCol umn | |
1126 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[n]" | |
1127 | dataType ="i4" | |
1128 | name="n" /> | |
1129 | <externalM etadataCol umn | |
1130 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[o]" | |
1131 | dataType ="i4" | |
1132 | name="o" /> | |
1133 | <externalM etadataCol umn | |
1134 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[p]" | |
1135 | dataType ="i4" | |
1136 | name="p" /> | |
1137 | <externalM etadataCol umn | |
1138 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[q]" | |
1139 | dataType ="i4" | |
1140 | name="q" /> | |
1141 | <externalM etadataCol umn | |
1142 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[r]" | |
1143 | dataType ="i4" | |
1144 | name="r" /> | |
1145 | <externalM etadataCol umn | |
1146 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[s]" | |
1147 | dataType ="i4" | |
1148 | name="s" /> | |
1149 | <externalM etadataCol umn | |
1150 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[t]" | |
1151 | dataType ="i4" | |
1152 | name="t" /> | |
1153 | <externalM etadataCol umn | |
1154 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[u]" | |
1155 | dataType ="i4" | |
1156 | name="u" /> | |
1157 | <externalM etadataCol umn | |
1158 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[v]" | |
1159 | dataType ="i4" | |
1160 | name="v" /> | |
1161 | <externalM etadataCol umn | |
1162 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[w]" | |
1163 | dataType ="i4" | |
1164 | name="w" /> | |
1165 | <externalM etadataCol umn | |
1166 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[x]" | |
1167 | dataType ="i4" | |
1168 | name="x" /> | |
1169 | <externalM etadataCol umn | |
1170 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[y]" | |
1171 | dataType ="i4" | |
1172 | name="y" /> | |
1173 | <externalM etadataCol umn | |
1174 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[z]" | |
1175 | dataType ="i4" | |
1176 | name="z" /> | |
1177 | <externalM etadataCol umn | |
1178 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[tot al]" | |
1179 | dataType ="i4" | |
1180 | name="to tal" /> | |
1181 | <externalM etadataCol umn | |
1182 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[fsp ace]" | |
1183 | dataType ="i4" | |
1184 | name="fs pace" /> | |
1185 | <externalM etadataCol umn | |
1186 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[fda sh]" | |
1187 | dataType ="i4" | |
1188 | name="fd ash" /> | |
1189 | <externalM etadataCol umn | |
1190 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[fap ostrophe]" | |
1191 | dataType ="i4" | |
1192 | name="fa postrophe" /> | |
1193 | <externalM etadataCol umn | |
1194 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[add ress]" | |
1195 | codePage ="1252" | |
1196 | dataType ="str" | |
1197 | length=" 8000" | |
1198 | name="ad dress" /> | |
1199 | <externalM etadataCol umn | |
1200 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[lin e1]" | |
1201 | codePage ="1252" | |
1202 | dataType ="str" | |
1203 | length=" 8000" | |
1204 | name="li ne1" /> | |
1205 | <externalM etadataCol umn | |
1206 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[lin e2]" | |
1207 | codePage ="1252" | |
1208 | dataType ="str" | |
1209 | length=" 8000" | |
1210 | name="li ne2" /> | |
1211 | <externalM etadataCol umn | |
1212 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[cit y]" | |
1213 | codePage ="1252" | |
1214 | dataType ="str" | |
1215 | length=" 8000" | |
1216 | name="ci ty" /> | |
1217 | <externalM etadataCol umn | |
1218 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[sta te]" | |
1219 | codePage ="1252" | |
1220 | dataType ="str" | |
1221 | length=" 8000" | |
1222 | name="st ate" /> | |
1223 | <externalM etadataCol umn | |
1224 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[zip ]" | |
1225 | codePage ="1252" | |
1226 | dataType ="str" | |
1227 | length=" 8000" | |
1228 | name="zi p" /> | |
1229 | <externalM etadataCol umn | |
1230 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[thr ead__id]" | |
1231 | dataType ="numeric" | |
1232 | name="th read__id" | |
1233 | precisio n="18" /> | |
1234 | <externalM etadataCol umn | |
1235 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Output] .ExternalC olumns[Bat chLogID]" | |
1236 | dataType ="i8" | |
1237 | name="Ba tchLogID" /> | |
1238 | </ externalMe tadataColu mns> | |
1239 | </ou tput> | |
1240 | <out put | |
1241 | re fId="Packa ge\Data Fl ow Task 1\ Source - _ fbcshcfapr ovider.Out puts[OLE D B Source E rror Outpu t]" | |
1242 | is ErrorOut=" true" | |
1243 | na me="OLE DB Source Er ror Output "> | |
1244 | <o utputColum ns> | |
1245 | <outputCol umn | |
1246 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[stati on__no]" | |
1247 | codePage ="1252" | |
1248 | dataType ="str" | |
1249 | length=" 30" | |
1250 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[s tation__no ]" | |
1251 | name="st ation__no" /> | |
1252 | <outputCol umn | |
1253 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[id]" | |
1254 | dataType ="i8" | |
1255 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[i d]" | |
1256 | name="id " /> | |
1257 | <outputCol umn | |
1258 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[provi dername]" | |
1259 | codePage ="1252" | |
1260 | dataType ="str" | |
1261 | length=" 8000" | |
1262 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[p rovidernam e]" | |
1263 | name="pr ovidername " /> | |
1264 | <outputCol umn | |
1265 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[a]" | |
1266 | dataType ="i4" | |
1267 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[a ]" | |
1268 | name="a" /> | |
1269 | <outputCol umn | |
1270 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[b]" | |
1271 | dataType ="i4" | |
1272 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[b ]" | |
1273 | name="b" /> | |
1274 | <outputCol umn | |
1275 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[c]" | |
1276 | dataType ="i4" | |
1277 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[c ]" | |
1278 | name="c" /> | |
1279 | <outputCol umn | |
1280 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[d]" | |
1281 | dataType ="i4" | |
1282 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[d ]" | |
1283 | name="d" /> | |
1284 | <outputCol umn | |
1285 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[e]" | |
1286 | dataType ="i4" | |
1287 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[e ]" | |
1288 | name="e" /> | |
1289 | <outputCol umn | |
1290 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[f]" | |
1291 | dataType ="i4" | |
1292 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[f ]" | |
1293 | name="f" /> | |
1294 | <outputCol umn | |
1295 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[g]" | |
1296 | dataType ="i4" | |
1297 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[g ]" | |
1298 | name="g" /> | |
1299 | <outputCol umn | |
1300 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[h]" | |
1301 | dataType ="i4" | |
1302 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[h ]" | |
1303 | name="h" /> | |
1304 | <outputCol umn | |
1305 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[i]" | |
1306 | dataType ="i4" | |
1307 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[i ]" | |
1308 | name="i" /> | |
1309 | <outputCol umn | |
1310 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[j]" | |
1311 | dataType ="i4" | |
1312 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[j ]" | |
1313 | name="j" /> | |
1314 | <outputCol umn | |
1315 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[k]" | |
1316 | dataType ="i4" | |
1317 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[k ]" | |
1318 | name="k" /> | |
1319 | <outputCol umn | |
1320 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[l]" | |
1321 | dataType ="i4" | |
1322 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[l ]" | |
1323 | name="l" /> | |
1324 | <outputCol umn | |
1325 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[m]" | |
1326 | dataType ="i4" | |
1327 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[m ]" | |
1328 | name="m" /> | |
1329 | <outputCol umn | |
1330 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[n]" | |
1331 | dataType ="i4" | |
1332 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[n ]" | |
1333 | name="n" /> | |
1334 | <outputCol umn | |
1335 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[o]" | |
1336 | dataType ="i4" | |
1337 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[o ]" | |
1338 | name="o" /> | |
1339 | <outputCol umn | |
1340 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[p]" | |
1341 | dataType ="i4" | |
1342 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[p ]" | |
1343 | name="p" /> | |
1344 | <outputCol umn | |
1345 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[q]" | |
1346 | dataType ="i4" | |
1347 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[q ]" | |
1348 | name="q" /> | |
1349 | <outputCol umn | |
1350 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[r]" | |
1351 | dataType ="i4" | |
1352 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[r ]" | |
1353 | name="r" /> | |
1354 | <outputCol umn | |
1355 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[s]" | |
1356 | dataType ="i4" | |
1357 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[s ]" | |
1358 | name="s" /> | |
1359 | <outputCol umn | |
1360 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[t]" | |
1361 | dataType ="i4" | |
1362 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[t ]" | |
1363 | name="t" /> | |
1364 | <outputCol umn | |
1365 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[u]" | |
1366 | dataType ="i4" | |
1367 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[u ]" | |
1368 | name="u" /> | |
1369 | <outputCol umn | |
1370 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[v]" | |
1371 | dataType ="i4" | |
1372 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[v ]" | |
1373 | name="v" /> | |
1374 | <outputCol umn | |
1375 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[w]" | |
1376 | dataType ="i4" | |
1377 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[w ]" | |
1378 | name="w" /> | |
1379 | <outputCol umn | |
1380 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[x]" | |
1381 | dataType ="i4" | |
1382 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[x ]" | |
1383 | name="x" /> | |
1384 | <outputCol umn | |
1385 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[y]" | |
1386 | dataType ="i4" | |
1387 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[y ]" | |
1388 | name="y" /> | |
1389 | <outputCol umn | |
1390 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[z]" | |
1391 | dataType ="i4" | |
1392 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[z ]" | |
1393 | name="z" /> | |
1394 | <outputCol umn | |
1395 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[total ]" | |
1396 | dataType ="i4" | |
1397 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[t otal]" | |
1398 | name="to tal" /> | |
1399 | <outputCol umn | |
1400 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[fspac e]" | |
1401 | dataType ="i4" | |
1402 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[f space]" | |
1403 | name="fs pace" /> | |
1404 | <outputCol umn | |
1405 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[fdash ]" | |
1406 | dataType ="i4" | |
1407 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[f dash]" | |
1408 | name="fd ash" /> | |
1409 | <outputCol umn | |
1410 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[fapos trophe]" | |
1411 | dataType ="i4" | |
1412 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[f apostrophe ]" | |
1413 | name="fa postrophe" /> | |
1414 | <outputCol umn | |
1415 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[addre ss]" | |
1416 | codePage ="1252" | |
1417 | dataType ="str" | |
1418 | length=" 8000" | |
1419 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[a ddress]" | |
1420 | name="ad dress" /> | |
1421 | <outputCol umn | |
1422 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[line1 ]" | |
1423 | codePage ="1252" | |
1424 | dataType ="str" | |
1425 | length=" 8000" | |
1426 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[l ine1]" | |
1427 | name="li ne1" /> | |
1428 | <outputCol umn | |
1429 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[line2 ]" | |
1430 | codePage ="1252" | |
1431 | dataType ="str" | |
1432 | length=" 8000" | |
1433 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[l ine2]" | |
1434 | name="li ne2" /> | |
1435 | <outputCol umn | |
1436 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[city] " | |
1437 | codePage ="1252" | |
1438 | dataType ="str" | |
1439 | length=" 8000" | |
1440 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[c ity]" | |
1441 | name="ci ty" /> | |
1442 | <outputCol umn | |
1443 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[state ]" | |
1444 | codePage ="1252" | |
1445 | dataType ="str" | |
1446 | length=" 8000" | |
1447 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[s tate]" | |
1448 | name="st ate" /> | |
1449 | <outputCol umn | |
1450 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[zip]" | |
1451 | codePage ="1252" | |
1452 | dataType ="str" | |
1453 | length=" 8000" | |
1454 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[z ip]" | |
1455 | name="zi p" /> | |
1456 | <outputCol umn | |
1457 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[threa d__id]" | |
1458 | dataType ="numeric" | |
1459 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[t hread__id] " | |
1460 | name="th read__id" | |
1461 | precisio n="18" /> | |
1462 | <outputCol umn | |
1463 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[Batch LogID]" | |
1464 | dataType ="i8" | |
1465 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[B atchLogID] " | |
1466 | name="Ba tchLogID" /> | |
1467 | <outputCol umn | |
1468 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[Error Code]" | |
1469 | dataType ="i4" | |
1470 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[E rrorCode]" | |
1471 | name="Er rorCode" | |
1472 | specialF lags="1" / > | |
1473 | <outputCol umn | |
1474 | refId="P ackage\Dat a Flow Tas k 1\Source - _fbcshc faprovider .Outputs[O LE DB Sour ce Error O utput].Col umns[Error Column]" | |
1475 | dataType ="i4" | |
1476 | lineageI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Err or Output] .Columns[E rrorColumn ]" | |
1477 | name="Er rorColumn" | |
1478 | specialF lags="2" / > | |
1479 | </ outputColu mns> | |
1480 | <e xternalMet adataColum ns /> | |
1481 | </ou tput> | |
1482 | </outp uts> | |
1483 | </compon ent> | |
1484 | </componen ts> | |
1485 | <paths> | |
1486 | <path | |
1487 | refId= "Package\D ata Flow T ask 1.Path s[OLE DB S ource Outp ut]" | |
1488 | endId= "Package\D ata Flow T ask 1\Dest ination - FBCSHCFACl aimProvide rInformati on.Inputs[ Destinatio n Input]" | |
1489 | name=" OLE DB Sou rce Output " | |
1490 | startI d="Package \Data Flow Task 1\So urce - _fb cshcfaprov ider.Outpu ts[OLE DB Source Out put]" /> | |
1491 | </paths> | |
1492 | </ pipeline> | |
1493 | </DT S:ObjectDa ta> | |
1494 | </DTS: Executable > | |
1495 | <DTS:E xecutable | |
1496 | DTS: refId="Pac kage\Prepa ration SQL Task 1" | |
1497 | DTS: CreationNa me="Micros oft.Execut eSQLTask" | |
1498 | DTS: DTSID="{7D 0A21E2-D73 6-4025-B07 6-2757A809 D5AA}" | |
1499 | DTS: Executable Type="Micr osoft.Exec uteSQLTask " | |
1500 | DTS: FailPackag eOnFailure ="True" | |
1501 | DTS: LocaleID=" -1" | |
1502 | DTS: ObjectName ="Preparat ion SQL Ta sk 1" | |
1503 | 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" | |
1504 | DTS: ThreadHint ="0"> | |
1505 | <DTS :Variables /> | |
1506 | <DTS :ObjectDat a> | |
1507 | <S QLTask:Sql TaskData | |
1508 | SQLTask:Co nnection=" {04DC2365- 7DDA-4269- B671-507D1 C175E3F}" | |
1509 | SQLTask:Sq lStatement Source="CR EATE TABLE [CallCent er].[FBCSH CFAClaimPr oviderInfo rmation] ( 
[Stat ion_Number ] varchar( 30) NOT NU LL,
[F BCSHFCACla imProvider Informatio n_ID] bigi nt,
[P rovider_Na me] varcha r(8000),&# xA;[Provid er_Names_O ccurrences _with_A] i nt,
[P rovider_Na mes_Occurr ences_with _B] int,&# xA;[Provid er_Names_O ccurrences _with_C] i nt,
[P rovider_Na mes_Occurr ences_with _D] int,&# xA;[Provid er_Names_O ccurrences _with_E] i nt,
[P rovider_Na mes_Occurr ences_with _F] int,&# xA;[Provid er_Names_O ccurrences _with_G] i nt,
[P rovider_Na mes_Occurr ences_with _H] int,&# xA;[iProvi der_Names_ Occurrence s_with_I] int,
[ Provider_N ames_Occur rences_wit h_J] int,& #xA;[Provi der_Names_ Occurrence s_with_K] int,
[ Provider_N ames_Occur rences_wit h_L] int,& #xA;[Provi der_Names_ Occurrence s_with_M] int,
[ Provider_N ames_Occur rences_wit h_N] int,& #xA;[Provi der_Names_ Occurrence s_with_O] int,
[ Provider_N ames_Occur rences_wit h_P] int,& #xA;[Provi der_Names_ Occurrence s_with_Q] int,
[ Provider_N ames_Occur rences_wit h_R] int,& #xA;[Provi der_Names_ Occurrence s_with_S] int,
[ Provider_N ames_Occur rences_wit h_T] int,& #xA;[Provi der_Names_ Occurrence s_with_U] int,
[ Provider_N ames_Occur rences_wit h_V] int,& #xA;[Provi der_Names_ Occurrence s_with_W] int,
[ Provider_N ames_Occur rences_wit h_X] int,& #xA;[Provi der_Names_ Occurrence s_with_Y] int,
[ Provider_N ames_Occur rences_wit h_Z] int,& #xA;[Total _Number_of _Character s_InProvid erName] in t,
[To tal_Number _of_Spaces _InProvide rName] int ,
[Tot al_Number_ of_Dashes_ InProvider Name] int, 
[Tota l_Number_o f_Apostrop hes_InProv iderName] int,
[ Complete_A ddress] va rchar(8000 ),
[Ad dress_Line 1] varchar (8000),&#x A;[Address _Line2] va rchar(8000 ),
[Ci ty] varcha r(8000),&# xA;[State] varchar(8 000),
 [Zip] varc har(8000), 
[Thre ad_ID] num eric(18,0) NOT NULL, 
[Batc hLog_ID] b igint
 )
GO&# xA;" xmlns :SQLTask=" www.micros oft.com/sq lserver/dt s/tasks/sq ltask" /> | |
1510 | </DT S:ObjectDa ta> | |
1511 | </DTS: Executable > | |
1512 | </DTS:Ex ecutables> | |
1513 | <DTS:Pre cedenceCon straints> | |
1514 | <DTS:P recedenceC onstraint | |
1515 | DTS: refId="Pac kage.Prece denceConst raints[{F4 FC35BC-A96 3-460F-8FB 4-5FEFE33A 5B41\}]" | |
1516 | DTS: CreationNa me="" | |
1517 | DTS: DTSID="{F4 FC35BC-A96 3-460F-8FB 4-5FEFE33A 5B41}" | |
1518 | DTS: From="Pack age\Prepar ation SQL Task 1" | |
1519 | DTS: LogicalAnd ="True" | |
1520 | DTS: ObjectName ="{F4FC35B C-A963-460 F-8FB4-5FE FE33A5B41} " | |
1521 | DTS: To="Packag e\Data Flo w Task 1" /> | |
1522 | </DTS:Pr ecedenceCo nstraints> | |
1523 | <DTS:Des ignTimePro perties><! [CDATA[<?x ml version ="1.0"?> | |
1524 | <!--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.- -> | |
1525 | <!--If you manually edit this section an d make a m istake, yo u can dele te it. --> | |
1526 | <!--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.--> | |
1527 | <Objects | |
1528 | Version= "8"> | |
1529 | <!--Each node belo w will con tain prope rties that do not af fect runti me behavio r.--> | |
1530 | <Package | |
1531 | design -time-name ="Package" > | |
1532 | <Layou tInfo> | |
1533 | <Gra phLayout | |
1534 | 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 "> | |
1535 | <N odeLayout | |
1536 | Size="160, 42" | |
1537 | Id="Packag e\Data Flo w Task 1" | |
1538 | TopLeft="2 0.5,107.5" /> | |
1539 | <N odeLayout | |
1540 | Size="190, 42" | |
1541 | Id="Packag e\Preparat ion SQL Ta sk 1" | |
1542 | TopLeft="5 .500000000 00001,5.5" /> | |
1543 | <E dgeLayout | |
1544 | Id="Packag e.Preceden ceConstrai nts[{F4FC3 5BC-A963-4 60F-8FB4-5 FEFE33A5B4 1\}]" | |
1545 | TopLeft="1 00.5,47.5" > | |
1546 | <EdgeLayou t.Curve> | |
1547 | <mssgle: Curve | |
1548 | StartC onnector=" {assembly: Null}" | |
1549 | EndCon nector="0, 60" | |
1550 | Start= "0,0" | |
1551 | End="0 ,52.5"> | |
1552 | <mssgl e:Curve.Se gments> | |
1553 | <mss gle:Segmen tCollectio n | |
1554 | Ca pacity="5" > | |
1555 | <m ssgle:Line Segment | |
1556 | End="0,52. 5" /> | |
1557 | </ms sgle:Segme ntCollecti on> | |
1558 | </mssg le:Curve.S egments> | |
1559 | </mssgle :Curve> | |
1560 | </EdgeLayo ut.Curve> | |
1561 | <EdgeLayou t.Labels> | |
1562 | <EdgeLab elCollecti on /> | |
1563 | </EdgeLayo ut.Labels> | |
1564 | </ EdgeLayout > | |
1565 | </Gr aphLayout> | |
1566 | </Layo utInfo> | |
1567 | </Packag e> | |
1568 | </Objects> ]]></DTS:D esignTimeP roperties> | |
1569 | </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.