|
![]() |
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 |
Name | Connection Manager | Description |
OleDbConnection |
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 |
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 |
Name | ID | LineageID |
ErrorCode |
7670 |
7670 |
ErrorColumn |
7671 |
7671 |
Powered by BI Documenter |