260. EPMO Open Source Coordination Office Redaction File Detail Report

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.

260.1 Files compared

# 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

260.2 Comparison summary

Description Between
Files 1 and 2
Text Blocks Lines
Unchanged 4 3130
Changed 3 8
Inserted 0 0
Removed 0 0

260.3 Comparison options

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

260.4 Active regular expressions

No regular expressions were active.

260.5 Comparison detail

  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="
D NS             "
  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] ( &#xA;[Stat ion_Number ] varchar( 30) NOT NU LL,&#xA;[F BCSHFCACla imProvider Informatio n_ID] bigi nt,&#xA;[P rovider_Na me] varcha r(8000),&# xA;[Provid er_Names_O ccurrences _with_A] i nt,&#xA;[P rovider_Na mes_Occurr ences_with _B] int,&# xA;[Provid er_Names_O ccurrences _with_C] i nt,&#xA;[P rovider_Na mes_Occurr ences_with _D] int,&# xA;[Provid er_Names_O ccurrences _with_E] i nt,&#xA;[P rovider_Na mes_Occurr ences_with _F] int,&# xA;[Provid er_Names_O ccurrences _with_G] i nt,&#xA;[P rovider_Na mes_Occurr ences_with _H] int,&# xA;[iProvi der_Names_ Occurrence s_with_I]  int,&#xA;[ Provider_N ames_Occur rences_wit h_J] int,& #xA;[Provi der_Names_ Occurrence s_with_K]  int,&#xA;[ Provider_N ames_Occur rences_wit h_L] int,& #xA;[Provi der_Names_ Occurrence s_with_M]  int,&#xA;[ Provider_N ames_Occur rences_wit h_N] int,& #xA;[Provi der_Names_ Occurrence s_with_O]  int,&#xA;[ Provider_N ames_Occur rences_wit h_P] int,& #xA;[Provi der_Names_ Occurrence s_with_Q]  int,&#xA;[ Provider_N ames_Occur rences_wit h_R] int,& #xA;[Provi der_Names_ Occurrence s_with_S]  int,&#xA;[ Provider_N ames_Occur rences_wit h_T] int,& #xA;[Provi der_Names_ Occurrence s_with_U]  int,&#xA;[ Provider_N ames_Occur rences_wit h_V] int,& #xA;[Provi der_Names_ Occurrence s_with_W]  int,&#xA;[ Provider_N ames_Occur rences_wit h_X] int,& #xA;[Provi der_Names_ Occurrence s_with_Y]  int,&#xA;[ Provider_N ames_Occur rences_wit h_Z] int,& #xA;[Total _Number_of _Character s_InProvid erName] in t,&#xA;[To tal_Number _of_Spaces _InProvide rName] int ,&#xA;[Tot al_Number_ of_Dashes_ InProvider Name] int, &#xA;[Tota l_Number_o f_Apostrop hes_InProv iderName]  int,&#xA;[ Complete_A ddress] va rchar(8000 ),&#xA;[Ad dress_Line 1] varchar (8000),&#x A;[Address _Line2] va rchar(8000 ),&#xA;[Ci ty] varcha r(8000),&# xA;[State]  varchar(8 000),&#xA; [Zip] varc har(8000), &#xA;[Thre ad_ID] num eric(18,0)  NOT NULL, &#xA;[Batc hLog_ID] b igint&#xA; )&#xA;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>