|
![]() |
Property | Value |
Name | OLE_DST Load New Temp table for Position |
Description | OLE DB Destination |
Up Stream Components | |
Down Stream Components | none |
ID | 7189 |
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 Position" (7189) |
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_DimPosition__New] |
OpenRowsetVariable |
|
SqlCommand |
Name | ID | LineageID |
Budgeted |
8471 |
8220 |
CountOfActiveAssignments |
8477 |
8226 |
CountOfInactiveAssignments |
8478 |
8227 |
DateEstablished |
8465 |
8214 |
DateInactivated |
8466 |
8215 |
ExemptStatus |
8474 |
8223 |
FulltimeEquivalent |
8482 |
8231 |
FunctionCode |
8463 |
8212 |
FunctionDescription |
8464 |
8213 |
InactiveReason |
8480 |
8229 |
InactiveReasonCode |
8479 |
8228 |
InactiveVacantDateRange |
8609 |
8594 |
JobClassCode |
8469 |
8218 |
JobGroup |
8468 |
8217 |
JobGroupCode |
8467 |
8216 |
Location |
8557 |
8531 |
LocationCode |
8556 |
8530 |
MultipleFunds |
8663 |
8646 |
PayBasis |
8470 |
8219 |
PooledIndicator |
8473 |
8222 |
PositionAK |
8457 |
8206 |
PositionCode |
8458 |
8207 |
PositionFulltimeParttime |
8475 |
8224 |
PositionStatus |
8460 |
8209 |
PositionTitle |
8459 |
8208 |
PositionType |
8462 |
8211 |
PositionTypeCode |
8461 |
8210 |
PrimarySalaryAccountNumber |
8476 |
8225 |
RegularTemporary |
8472 |
8221 |
RowEndDate |
7699 |
7691 |
RowIsCurrent |
7697 |
7667 |
RowStartDate |
7698 |
7683 |
WeeklyAuthorizedHours |
8483 |
8232 |
Name | ID | LineageID |
ErrorCode |
7204 |
7204 |
ErrorColumn |
7205 |
7205 |
Powered by BI Documenter |