DimStudentObjectiveLoad
 OLE_DEST Load Verification Temp Table into DWOperations (Component)
  Properties
Property Value
Name OLE_DEST Load Verification Temp Table into DWOperations
Description OLE DB Destination
Up Stream Components
Down Stream Components none
ID 1154
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_DEST Load Verification Temp Table into DWOperations" (1154)
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].[Verify_dbo_DimStudentObjective]
OpenRowsetVariable
SqlCommand
  Input Columns
Name ID LineageID
ActualGraduationTerm
1567
1486
ActualGraduationTermTitle
1568
1489
AdmissionStatus
1561
1468
AwardType
1263
863
AwardTypeCode
1262
860
EffectiveTerm
1558
1459
EffectiveTermTitle
1559
1462
ExpectedGraduationTerm
1565
1480
ExpectedGraduationTermTitle
1566
1483
GraduationAge
1643
1604
GraduationAgeRange
1644
1607
GraduationHonorsCode
1569
1492
GraduationStatusCode
1564
1477
PrimaryObjective
1562
1471
Program
1253
833
ProgramCode
1252
830
ProgramStatusCode
1563
1474
ReportedTerm
1574
1507
ReportedTermTitle
1575
1510
RowIsDuplicate
1652
1646
RowIsSelected
1653
1649
SequenceNumber
1560
1465
StudentId
1249
821
StudentObjectiveAK
1557
1456
TransferInstitution
1573
1504
TransferInstitutionId
1572
1501
TransferMajor
1571
1498
TransferMajorCode
1570
1495
  Output Columns
Name ID LineageID
ErrorCode
1169
1169
ErrorColumn
1170
1170
Powered by BI Documenter