|
![]() |
Property | Value |
Name | OLE_DST Load SCD1 Temp Table for Application |
Description | OLE DB Destination |
Up Stream Components | |
Down Stream Components | none |
ID | 2494 |
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 Application" (2494) |
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_DimApplication__Type1Update] |
OpenRowsetVariable |
|
SqlCommand |
Name | ID | LineageID |
ApplicationAK |
3523 |
3412 |
ApplicationDate |
3540 |
3429 |
ApplicationEntry |
3526 |
3415 |
ApplicationSK |
3522 |
3411 |
ApplicationTerm |
3524 |
3413 |
ApplicationTermTitle |
3525 |
3414 |
ApplicationType |
3528 |
3417 |
ApplicationTypeCode |
3527 |
3416 |
AwardType |
3539 |
3428 |
AwardTypeCode |
3538 |
3427 |
BachelorApplicant |
3535 |
3424 |
BasisOfAdmission |
3532 |
3421 |
BasisOfAdmissionCode |
3531 |
3420 |
CreditVocationalBachelorApplication |
3529 |
3418 |
EnrollmentStatus |
3534 |
3423 |
EnrollmentStatusCode |
3533 |
3422 |
FirstTermEnrolled |
3541 |
3430 |
FirstTermEnrolledTitle |
3542 |
3431 |
FirstTimeInCollege |
2645 |
1448 |
HomeCampus |
3126 |
3122 |
HomeCampusCode |
3125 |
3121 |
InitialOrReadmitApplication |
3530 |
3419 |
Program |
3537 |
3426 |
ProgramCode |
3536 |
3425 |
StudentId |
2657 |
1461 |
Name | ID | LineageID |
ErrorCode |
2509 |
2509 |
ErrorColumn |
2510 |
2510 |
Powered by BI Documenter |