264. EPMO Open Source Coordination Office Redaction File Detail Report

Produced by Araxis Merge on 5/2/2019 1:18:56 PM Central Daylight Time. See www.araxis.com for information about Merge. This report uses XHTML and CSS2, and is best viewed with a modern standards-compliant browser. For optimum results when printing this report, use landscape orientation and enable printing of background images and colours in your browser.

264.1 Files compared

# Location File Last Modified
1 C:\AraxisMergeCompare\Pri_un\EPRS\EPRS_SSIS\EPRS.SSIS\EPRS.SSIS Transfermation HCFAEdit-CookieCutter.dtsx Thu Apr 18 16:53:26 2019 UTC
2 C:\AraxisMergeCompare\Pri_re\EPRS\EPRS_SSIS\EPRS.SSIS\EPRS.SSIS Transfermation HCFAEdit-CookieCutter.dtsx Wed May 1 13:06:11 2019 UTC

264.2 Comparison summary

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

264.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

264.4 Active regular expressions

No regular expressions were active.

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