OLE_SRC Verification Temp table from Student Success Staging - Component

Properties

Property	Value
Name	OLE_SRC Verification Temp table from Student Success Staging
Description	OLE DB Source
Up Stream Components	none
Down Stream Components	DER Stub Fields
ID	1
Component Class ID	{BCEFE59B-6819-47F7-A125-63753B33ABB7}
Contact Info	OLE DB Source;Microsoft Corporation; Microsoft SqlServer v10; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;7
Identification String	component "OLE_SRC Verification Temp table from Student Success Staging" (1)
Is Default Locale	True
Pipeline Version	0
Uses Dispositions	True
Validate External Metadata	True
Version	7

Connections

Name	Connection Manager	Description
OleDbConnection	DWStaging

Custom Properties

Name	Value
AccessMode	3
AlwaysUseDefaultCodePage	False
CommandTimeout	0
DefaultCodePage	1252
OpenRowset
OpenRowsetVariable
ParameterMapping
SqlCommand	select 1 as A
SqlCommandVariable	User::GetStudentSuccessMods

Input Columns

Name

ID

LineageID

Output Columns

Name	ID	LineageID
AwardType	864	864
AwardTypeCode	861	861
CohortTerm	1710	1710
CohortTermTitle	1713	1713
ErrorCode	13	13
ErrorColumn	14	14
FirstTerm_FT_PT	1722	1722
FirstYearTerm	1742	1742
InitialPrepStatus	1719	1719
LastTermCaptured	1773	1773
LastTermCapturedTitle	1776	1776
Program	834	834
ProgramAdmitStatus	1716	1716
ProgramCode	831	831
StudentId	822	822
StudentSuccessCohortAK	1707	1707
AwardType	863	863
AwardTypeCode	860	860
CohortTerm	1709	1709
CohortTermTitle	1712	1712
FirstTerm_FT_PT	1721	1721
FirstYearTerm	1741	1741
InitialPrepStatus	1718	1718
LastTermCaptured	1772	1772
LastTermCapturedTitle	1775	1775
Program	833	833
ProgramAdmitStatus	1715	1715
ProgramCode	830	830
StudentId	821	821
StudentSuccessCohortAK	1706	1706

Powered by BI Documenter