FactStudentGradesLoad
 OLE DB Student Grades Staging (Component)
  Properties
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
  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
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
  Output Columns
Name ID LineageID
ErrorCode
463
463
ErrorColumn
464
464
Powered by BI Documenter