|
![]() |
Property | Value |
Name | OLE DB Student Grades Staging |
Description | OLE DB Destination |
Up Stream Components | |
Down Stream Components | none |
ID | 448 |
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 DB Student Grades Staging" (448) |
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 |
CHECK_CONSTRAINTS |
OpenRowset |
[dbo].[FactStudentGrades_Staging] |
OpenRowsetVariable |
|
SqlCommand |
Name | ID | LineageID |
Attempt1 |
1323 |
1191 |
Attempt2 |
1324 |
1194 |
Attempt2OrMore |
1325 |
1197 |
Attempt3OrMore |
1326 |
1200 |
GradeA |
1310 |
1152 |
GradeB |
1311 |
1155 |
GradeByLetterOther |
1322 |
1188 |
GradeC |
1312 |
1158 |
GradeD |
1313 |
1161 |
GradeF |
1314 |
1164 |
GradeFail |
1307 |
1143 |
GradeI |
1321 |
1185 |
GradeMarginal |
1306 |
1140 |
GradeN |
1319 |
1179 |
GradeOther |
1309 |
1149 |
GradeP |
1317 |
1173 |
GradeS |
1316 |
1170 |
GradeSuccess |
1305 |
1137 |
GradeU |
1318 |
1176 |
GradeW |
1315 |
1167 |
GradeWithdrawal |
1308 |
1146 |
GradeX |
1320 |
1182 |
RefNum |
1304 |
1134 |
StudentId |
1302 |
1128 |
Term |
1394 |
1388 |
Name | ID | LineageID |
ErrorCode |
463 |
463 |
ErrorColumn |
464 |
464 |
Powered by BI Documenter |