DimPayeeLoad
 OLE_DEST Load Verification table Payee from Employee (Component)
  Properties
Property Value
Name OLE_DEST Load Verification table Payee from Employee
Description OLE DB Destination
Up Stream Components
Down Stream Components none
ID 2234
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_DEST Load Verification table Payee from Employee" (2234)
Is Default Locale False
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].[Verify_dbo_DimPayee]
OpenRowsetVariable
SqlCommand
  Input Columns
Name ID LineageID
Country
2260
2196
IsMinority
2256
2184
PayeeAK
2250
2166
PayeeId
2251
2169
PayeeName
2255
2181
PayeeNameConsolidated
2331
2317
PayeeSequence
2252
2172
PayeeType
2254
2178
PayeeTypeCode
2253
2175
RowIsDuplicate
2248
2201
RowIsSelected
2249
2204
State
2258
2190
StateCode
2257
2187
ZipCode
2259
2193
  Output Columns
Name ID LineageID
ErrorCode
2276
2276
ErrorColumn
2277
2277
Powered by BI Documenter