DimPayeeLoad
 OLE_DST Load New Temp table for Payee (Component)
  Properties
Property Value
Name OLE_DST Load New Temp table for Payee
Description OLE DB Destination
Up Stream Components
Down Stream Components none
ID 7672
Component Class ID {5A0B62E8-D91D-49F5-94A5-7BE58DE508F0}
Contact Info OLE DB Destination;Microsoft Corporation; Microsoft SqlServer v10; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;4
Identification String component "OLE_DST Load New Temp table for Payee" (7672)
Is Default Locale True
Pipeline Version 0
Uses Dispositions True
Validate External Metadata True
Version 4
  Connections
Name Connection Manager Description
OleDbConnection
  Custom Properties
Name Value
AccessMode
3
AlwaysUseDefaultCodePage
False
CommandTimeout
0
DefaultCodePage
1252
FastLoadKeepIdentity
False
FastLoadKeepNulls
False
FastLoadMaxInsertCommitSize
2147483647
FastLoadOptions
TABLOCK,CHECK_CONSTRAINTS
OpenRowset
[dbo].[Staged_dbo_DimPayee__New]
OpenRowsetVariable
SqlCommand
  Input Columns
Name ID LineageID
Country
8327
8213
IsMinority
8323
8209
PayeeAK
8317
8203
PayeeId
8318
8204
PayeeName
8322
8208
PayeeNameConsolidated
8415
8398
PayeeSequence
8319
8205
PayeeType
8321
8207
PayeeTypeCode
8320
8206
RowEndDate
7727
7579
RowIsCurrent
7725
7577
RowStartDate
7726
7578
State
8325
8211
StateCode
8324
8210
ZipCode
8326
8212
  Output Columns
Name ID LineageID
ErrorCode
7687
7687
ErrorColumn
7688
7688
Powered by BI Documenter