DimStudentLoad
 OLE_DST Load SCD1 Temp Table for Student (Component)
  Properties
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
  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].[Staged_dbo_DimStudent__Type1Update]
OpenRowsetVariable
SqlCommand
  Input Columns
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
  Output Columns
Name ID LineageID
ErrorCode
2509
2509
ErrorColumn
2510
2510
Powered by BI Documenter