DimApplicationLoad
 OLE_DST Load New Temp Table for Application (Component)
  Properties
Property Value
Name OLE_DST Load New Temp Table for Application
Description OLE DB Destination
Up Stream Components
Down Stream Components none
ID 2099
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_DST Load New Temp Table for Application" (2099)
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].[Staged_dbo_DimApplication__New]
OpenRowsetVariable
SqlCommand
  Input Columns
Name ID LineageID
ApplicationAK
3563
3368
ApplicationDate
3580
3385
ApplicationEntry
3566
3371
ApplicationTerm
3564
3369
ApplicationTermTitle
3565
3370
ApplicationType
3568
3373
ApplicationTypeCode
3567
3372
AwardType
3579
3384
AwardTypeCode
3578
3383
BachelorApplicant
3575
3380
BasisOfAdmission
3572
3377
BasisOfAdmissionCode
3571
3376
CreditVocationalBachelorApplication
3569
3374
EnrollmentStatus
3574
3379
EnrollmentStatusCode
3573
3378
FirstTermEnrolled
3581
3386
FirstTermEnrolledTitle
3582
3387
FirstTimeInCollege
2186
1364
HomeCampus
3130
3116
HomeCampusCode
3129
3115
InitialOrReadmitApplication
3570
3375
Program
3577
3382
ProgramCode
3576
3381
RowEndDate
2221
2076
RowIsCurrent
2219
2074
RowStartDate
2220
2075
StudentId
2198
1377
  Output Columns
Name ID LineageID
ErrorCode
2114
2114
ErrorColumn
2115
2115
Powered by BI Documenter