|
![]() |
Property | Value |
Name | OLE_DST Load SCD1 Temp Table for Student |
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 Student" (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_DimStudent__Type1Update] |
OpenRowsetVariable |
|
SqlCommand |
Name | ID | LineageID |
CellPhoneNumber |
2663 |
1467 |
CountryOfBirth |
2674 |
1478 |
CountryOfBirthCode |
2673 |
1477 |
CountryOfCitizenship |
2676 |
1480 |
CountryOfCitizenshipCode |
2675 |
1479 |
DateOfBirth |
2650 |
1453 |
Ethnicity |
2644 |
1447 |
EthnicityCode |
2643 |
1446 |
FERPARequested |
2672 |
1476 |
FirstName |
2639 |
1442 |
FirstTimeInCollege |
2645 |
1448 |
FullName |
2658 |
1462 |
Gender |
2642 |
1445 |
GenderCode |
2641 |
1444 |
HighSchool |
2661 |
1465 |
HighSchoolInstitutionId |
2660 |
1464 |
HomeCampus |
3126 |
3122 |
HomeCampusCode |
3125 |
3121 |
HomePhoneNumber |
2662 |
1466 |
ImmigrationStatus |
2667 |
1471 |
ImmigrationStatusCode |
2666 |
1470 |
InitialPrepStatus |
3033 |
3007 |
InstitutionalEmailAddress |
2664 |
1468 |
InternationalStudent |
3036 |
3010 |
LastName |
2638 |
1441 |
MiddleName |
2640 |
1443 |
PersonalEmailAddress |
2665 |
1469 |
PrimaryLanguage |
2646 |
1449 |
PrimaryLanguageCode |
2659 |
1463 |
RaceAfricanAmerican |
2652 |
1455 |
RaceAmericanIndian |
2655 |
1458 |
RaceAsian |
2654 |
1457 |
RacePacificIslander |
2653 |
1456 |
RaceUnreported |
2656 |
1459 |
RaceWhite |
2651 |
1454 |
Residency |
2648 |
1451 |
ResidencyCode |
2647 |
1450 |
ResidencyCounty |
2669 |
1473 |
ResidencyCountyCode |
2668 |
1472 |
ResidencyState |
2671 |
1475 |
ResidencyStateCode |
2670 |
1474 |
StudentAthlete |
3035 |
3009 |
StudentId |
2657 |
1461 |
StudentIdAK |
2637 |
1440 |
VeteranStudent |
3034 |
3008 |
ZipCode |
2649 |
1452 |
Name | ID | LineageID |
ErrorCode |
2509 |
2509 |
ErrorColumn |
2510 |
2510 |
Powered by BI Documenter |