FactStudentGradesLoad
 OLE DB FactStudentGrades (Component)
  Properties
Property Value
Name OLE DB FactStudentGrades
Description OLE DB Destination
Up Stream Components
Down Stream Components none
ID 285
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 FactStudentGrades" (285)
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].[FactStudentGrades]
OpenRowsetVariable
SqlCommand
  Input Columns
Name ID LineageID
Attempt1
1554
1335
Attempt2
1555
1338
Attempt2OrMore
1556
1341
Attempt3OrMore
1557
1344
CurriculumSK
318
247
FTEClassificationSK
820
816
GradeA
1541
1296
GradeB
1542
1299
GradeByLetterOther
1553
1332
GradeC
1543
1302
GradeD
1544
1305
GradeF
1545
1308
GradeFail
1538
1287
GradeI
1552
1329
GradeMarginal
1537
1284
GradeN
1550
1323
GradeOther
1540
1293
GradeP
1548
1317
GradeS
1547
1314
GradeSuccess
1536
1281
GradeU
1549
1320
GradeW
1546
1311
GradeWithdrawal
1539
1290
GradeX
1551
1326
StudentSK
316
122
StudentTermSK
317
222
TermSK
583
460
  Output Columns
Name ID LineageID
ErrorCode
300
300
ErrorColumn
301
301
Powered by BI Documenter