DimPayeeLoad
 OLE_DST Load SCD1 temp table for Payee (Component)
  Properties
Property Value
Name OLE_DST Load SCD1 temp table for Payee
Description OLE DB Destination
Up Stream Components
Down Stream Components none
ID 7655
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 SCD1 temp table for Payee" (7655)
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__Type1Update]
OpenRowsetVariable
SqlCommand
  Input Columns
Name ID LineageID
Country
8305
8239
IsMinority
8301
8235
PayeeAK
8295
8229
PayeeId
8296
8230
PayeeName
8300
8234
PayeeNameConsolidated
8413
8402
PayeeSequence
8297
8231
PayeeSK
8294
8228
PayeeType
8299
8233
PayeeTypeCode
8298
8232
State
8303
8237
StateCode
8302
8236
ZipCode
8304
8238
  Output Columns
Name ID LineageID
ErrorCode
7670
7670
ErrorColumn
7671
7671
Powered by BI Documenter