FactStudentGradesLoad
 OLE DB Student Grades Staging Archived (Component)
  Properties
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
  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
CHECK_CONSTRAINTS
OpenRowset
[dbo].[FactStudentGrades_Staging]
OpenRowsetVariable
SqlCommand
  Input Columns
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
  Output Columns
Name ID LineageID
ErrorCode
1118
1118
ErrorColumn
1119
1119
Powered by BI Documenter