|
![]() |
Property | Value |
Name | OLE DB Student Grades Staging Archived |
Description | OLE DB Destination |
Up Stream Components | |
Down Stream Components | none |
ID | 1091 |
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 Archived" (1091) |
Is Default Locale | False |
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 |
1373 |
1266 |
Attempt2 |
1374 |
1269 |
Attempt2OrMore |
1375 |
1272 |
Attempt3OrMore |
1376 |
1275 |
GradeA |
1360 |
1227 |
GradeB |
1361 |
1230 |
GradeByLetterOther |
1372 |
1263 |
GradeC |
1362 |
1233 |
GradeD |
1363 |
1236 |
GradeF |
1364 |
1239 |
GradeFail |
1357 |
1218 |
GradeI |
1371 |
1260 |
GradeMarginal |
1356 |
1215 |
GradeN |
1369 |
1254 |
GradeOther |
1359 |
1224 |
GradeP |
1367 |
1248 |
GradeS |
1366 |
1245 |
GradeSuccess |
1355 |
1212 |
GradeU |
1368 |
1251 |
GradeW |
1365 |
1242 |
GradeWithdrawal |
1358 |
1221 |
GradeX |
1370 |
1257 |
RefNum |
1354 |
1209 |
StudentId |
1352 |
1203 |
Term |
1396 |
1391 |
Name | ID | LineageID |
ErrorCode |
1118 |
1118 |
ErrorColumn |
1119 |
1119 |
Powered by BI Documenter |