|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Name | OLE_DST Load New Temp Table for Student |
| Description | OLE DB Destination |
| Up Stream Components | |
| Down Stream Components | none |
| ID | 2099 |
| 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 New Temp Table for Student" (2099) |
| 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__New] |
OpenRowsetVariable |
|
SqlCommand |
Input Columns
| Name | ID | LineageID |
CellPhoneNumber |
2204 |
1383 |
CountryOfBirth |
2215 |
1394 |
CountryOfBirthCode |
2214 |
1393 |
CountryOfCitizenship |
2217 |
1396 |
CountryOfCitizenshipCode |
2216 |
1395 |
DateOfBirth |
2191 |
1369 |
Ethnicity |
2185 |
1363 |
EthnicityCode |
2184 |
1362 |
FERPARequested |
2213 |
1392 |
FirstName |
2180 |
1358 |
FirstTimeInCollege |
2186 |
1364 |
FullName |
2199 |
1378 |
Gender |
2183 |
1361 |
GenderCode |
2182 |
1360 |
HighSchool |
2202 |
1381 |
HighSchoolInstitutionId |
2201 |
1380 |
HomeCampus |
3130 |
3116 |
HomeCampusCode |
3129 |
3115 |
HomePhoneNumber |
2203 |
1382 |
ImmigrationStatus |
2208 |
1387 |
ImmigrationStatusCode |
2207 |
1386 |
InitialPrepStatus |
3041 |
2997 |
InstitutionalEmailAddress |
2205 |
1384 |
InternationalStudent |
3044 |
3000 |
LastName |
2179 |
1357 |
MiddleName |
2181 |
1359 |
PersonalEmailAddress |
2206 |
1385 |
PrimaryLanguage |
2187 |
1365 |
PrimaryLanguageCode |
2200 |
1379 |
RaceAfricanAmerican |
2193 |
1371 |
RaceAmericanIndian |
2196 |
1374 |
RaceAsian |
2195 |
1373 |
RacePacificIslander |
2194 |
1372 |
RaceUnreported |
2197 |
1375 |
RaceWhite |
2192 |
1370 |
Residency |
2189 |
1367 |
ResidencyCode |
2188 |
1366 |
ResidencyCounty |
2210 |
1389 |
ResidencyCountyCode |
2209 |
1388 |
ResidencyState |
2212 |
1391 |
ResidencyStateCode |
2211 |
1390 |
RowEndDate |
2221 |
2076 |
RowIsCurrent |
2219 |
2074 |
RowStartDate |
2220 |
2075 |
StudentAthlete |
3043 |
2999 |
StudentId |
2198 |
1377 |
StudentIdAK |
2178 |
1356 |
VeteranStudent |
3042 |
2998 |
ZipCode |
2190 |
1368 |
Output Columns
| Name | ID | LineageID |
ErrorCode |
2114 |
2114 |
ErrorColumn |
2115 |
2115 |
| Powered by BI Documenter |
