|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Name | OLE_DST Load verification Temp Table into DWOperations |
| Description | OLE DB Destination |
| Up Stream Components | |
| Down Stream Components | none |
| ID | 793 |
| 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 verification Temp Table into DWOperations" (793) |
| 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].[Verify_dbo_DimStudent] |
OpenRowsetVariable |
|
SqlCommand |
Input Columns
| Name | ID | LineageID |
CellPhoneNumber |
876 |
677 |
CountryOfBirth |
891 |
707 |
CountryOfBirthCode |
890 |
705 |
CountryOfCitizenship |
893 |
711 |
CountryOfCitizenshipCode |
892 |
709 |
DateOfBirth |
888 |
701 |
Ethnicity |
863 |
651 |
EthnicityCode |
862 |
649 |
FERPARequested |
889 |
703 |
FirstName |
857 |
639 |
FirstTimeInCollege |
864 |
653 |
Fullname |
859 |
643 |
Gender |
861 |
647 |
GenderCode |
860 |
645 |
HighSchool |
874 |
673 |
HighSchoolInstitutionId |
873 |
671 |
HomeCampus |
1085 |
1034 |
HomeCampusCode |
1084 |
1031 |
HomePhoneNumber |
875 |
675 |
ImmigrationStatus |
880 |
685 |
ImmigrationStatusCode |
879 |
683 |
InitialPrepStatus |
1026 |
967 |
InstitutionalEmailAddress |
877 |
679 |
InternationalStudent |
1029 |
976 |
LastName |
856 |
637 |
MiddleName |
858 |
641 |
PersonalEmailAddress |
878 |
681 |
PrimaryLanguage |
872 |
669 |
PrimaryLanguageCode |
871 |
667 |
RaceAfricanAmerican |
866 |
657 |
RaceAmericanIndian |
869 |
663 |
RaceAsian |
868 |
661 |
RacePacificIslander |
867 |
659 |
RaceUnreported |
870 |
665 |
RaceWhite |
865 |
655 |
Residency |
882 |
689 |
ResidencyCode |
881 |
687 |
ResidencyCounty |
884 |
693 |
ResidencyCountyCode |
883 |
691 |
ResidencyState |
886 |
697 |
ResidencyStateCode |
885 |
695 |
RowIsDuplicate |
894 |
165 |
RowIsSelected |
895 |
168 |
StudentAthlete |
1028 |
973 |
StudentId |
855 |
635 |
StudentIdAK |
854 |
633 |
VeteranStudent |
1027 |
970 |
ZipCode |
887 |
699 |
Output Columns
| Name | ID | LineageID |
ErrorCode |
808 |
808 |
ErrorColumn |
809 |
809 |
| Powered by BI Documenter |
