OLE_SRC Verification Temp Tables from Student Staging

Property	Value
Name	OLE_SRC Verification Temp Tables from Student Staging
Description	OLE DB Source
Up Stream Components	none
Down Stream Components	TF Transform Case
ID	1
Component Class ID	{BCEFE59B-6819-47F7-A125-63753B33ABB7}
Contact Info	OLE DB Source;Microsoft Corporation; Microsoft SqlServer v10; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;7
Identification String	component "OLE_SRC Verification Temp Tables from Student Staging" (1)
Is Default Locale	True
Pipeline Version	0
Uses Dispositions	True
Validate External Metadata	True
Version	7

Name	Connection Manager	Description
OleDbConnection	DWOperations

Name	Value
AccessMode	2
AlwaysUseDefaultCodePage	False
CommandTimeout	0
DefaultCodePage	1252
OpenRowset
OpenRowsetVariable
ParameterMapping
SqlCommand	SELECT VerifyStudentIdSK ,StudentIdAK ,StudentId ,FullName ,LastName ,FirstName ,MiddleName ,GenderCode ,Gender ,EthnicityCode ,Ethnicity ,FirstTimeInCollege ,PrimaryLanguageCode ,PrimaryLanguage ,HighSchoolInstitutionId ,HighSchool ,HomePhoneNumber ,CellPhoneNumber ,InstitutionalEmailAddress ,PersonalEmailAddress ,ImmigrationStatusCode ,ImmigrationStatus ,ResidencyCode ,Residency ,ResidencyCountyCode ,ResidencyCounty ,ResidencyStateCode ,ResidencyState ,ZipCode ,DateOfBirth ,FERPARequested ,RaceWhite ,RaceAfricanAmerican ,RacePacificIslander ,RaceAsian ,RaceAmericanIndian ,RaceUnreported ,CountryOfBirthCode ,CountryOfBirth ,CountryOfCitizenshipCode ,CountryOfCitizenship ,HomeCampusCode ,HomeCampus ,InitialPrepStatus ,VeteranStudent ,StudentAthlete ,InternationalStudent FROM dbo.Verify_dbo_DimStudent WHERE RowIsSelected = 'Y' ORDER BY StudentIdAK
SqlCommandVariable

Name

ID

LineageID

Name	ID	LineageID
CellPhoneNumber	947	947
CountryOfBirth	969	969
CountryOfBirthCode	967	967
CountryOfCitizenship	973	973
CountryOfCitizenshipCode	971	971
DateOfBirth	919	919
ErrorCode	13	13
ErrorColumn	14	14
Ethnicity	907	907
EthnicityCode	905	905
FERPARequested	965	965
FirstName	897	897
FirstTimeInCollege	909	909
FullName	937	937
Gender	903	903
GenderCode	901	901
HighSchool	943	943
HighSchoolInstitutionId	941	941
HomeCampus	3050	3050
HomeCampusCode	3047	3047
HomePhoneNumber	945	945
ImmigrationStatus	955	955
ImmigrationStatusCode	953	953
InitialPrepStatus	2912	2912
InstitutionalEmailAddress	949	949
InternationalStudent	2921	2921
LastName	895	895
MiddleName	899	899
PersonalEmailAddress	951	951
PrimaryLanguage	911	911
PrimaryLanguageCode	939	939
RaceAfricanAmerican	923	923
RaceAmericanIndian	929	929
RaceAsian	927	927
RacePacificIslander	925	925
RaceUnreported	931	931
RaceWhite	921	921
Residency	915	915
ResidencyCode	913	913
ResidencyCounty	959	959
ResidencyCountyCode	957	957
ResidencyState	963	963
ResidencyStateCode	961	961
StudentAthlete	2918	2918
StudentId	935	935
StudentIdAK	893	893
VerifyStudentIdSK	933	933
VeteranStudent	2915	2915
ZipCode	917	917
CellPhoneNumber	946	946
CountryOfBirth	968	968
CountryOfBirthCode	966	966
CountryOfCitizenship	972	972
CountryOfCitizenshipCode	970	970
DateOfBirth	918	918
Ethnicity	906	906
EthnicityCode	904	904
FERPARequested	964	964
FirstName	896	896
FirstTimeInCollege	908	908
FullName	936	936
Gender	902	902
GenderCode	900	900
HighSchool	942	942
HighSchoolInstitutionId	940	940
HomeCampus	3049	3049
HomeCampusCode	3046	3046
HomePhoneNumber	944	944
ImmigrationStatus	954	954
ImmigrationStatusCode	952	952
InitialPrepStatus	2911	2911
InstitutionalEmailAddress	948	948
InternationalStudent	2920	2920
LastName	894	894
MiddleName	898	898
PersonalEmailAddress	950	950
PrimaryLanguage	910	910
PrimaryLanguageCode	938	938
RaceAfricanAmerican	922	922
RaceAmericanIndian	928	928
RaceAsian	926	926
RacePacificIslander	924	924
RaceUnreported	930	930
RaceWhite	920	920
Residency	914	914
ResidencyCode	912	912
ResidencyCounty	958	958
ResidencyCountyCode	956	956
ResidencyState	962	962
ResidencyStateCode	960	960
StudentAthlete	2917	2917
StudentId	934	934
StudentIdAK	892	892
VerifyStudentIdSK	932	932
VeteranStudent	2914	2914
ZipCode	916	916