|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Name | OLE_DST Load SCD1 Temp Table for Curriculum |
| Description | OLE DB Destination |
| Up Stream Components | |
| Down Stream Components | none |
| ID | 4880 |
| 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 SCD1 Temp Table for Curriculum" (4880) |
| 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 |
True |
FastLoadMaxInsertCommitSize |
2147483647 |
FastLoadOptions |
TABLOCK,CHECK_CONSTRAINTS |
OpenRowset |
[dbo].[Staged_dbo_DimCurriculum__Type1Update] |
OpenRowsetVariable |
|
SqlCommand |
Input Columns
| Name | ID | LineageID |
Apprenticeship |
4990 |
4364 |
Campus |
4971 |
4343 |
CampusCode |
4970 |
4342 |
Center |
4973 |
4345 |
CenterCode |
4972 |
4344 |
ClassStatus |
4977 |
4349 |
ClassStatusCode |
4976 |
4348 |
ClassTitle |
4957 |
4329 |
CourseId |
4953 |
4325 |
CourseIdPrefix |
4956 |
4328 |
CourseLevel |
6218 |
6209 |
CourseNumberTimesForCredit |
5986 |
5947 |
CourseType |
4959 |
4331 |
CourseTypeCode |
4958 |
4330 |
CreditNonCredit |
4963 |
4335 |
CreditNonCreditVocational |
4960 |
4332 |
CreditNonCreditVocationalTest |
6355 |
6350 |
CreditType |
4962 |
4334 |
CreditTypeCode |
4961 |
4333 |
CurrentCourseId |
4955 |
4327 |
CurrentTerm |
4954 |
4326 |
CurriculumSK |
4948 |
4320 |
DeliveryMethod |
4980 |
4352 |
Department |
4969 |
4341 |
DepartmentCode |
4968 |
4340 |
DepartmentDescription |
6447 |
6437 |
Division |
4967 |
4339 |
DivisionCode |
4966 |
4338 |
DivisionDescription |
6446 |
6436 |
DualEnrollment |
4988 |
4362 |
Honors |
4986 |
4360 |
ICSCategoryCode |
5981 |
5942 |
ICSCode |
4964 |
4336 |
IndependentStudy |
4989 |
4363 |
InstructionalClassification |
4965 |
4337 |
InstructionalClassificationCategory |
5982 |
5943 |
IsCourseRepeatable |
6092 |
6078 |
IsTermCourseIdCountGE10 |
6091 |
6077 |
MaximumClassSize |
4975 |
4347 |
MinimumClassSize |
4974 |
4346 |
Online100Percent |
4992 |
4366 |
PrimaryInstructor |
4996 |
4353 |
PrimaryInstructorFirstName |
4983 |
4356 |
PrimaryInstructorFullName |
4981 |
4354 |
PrimaryInstructorInitial |
4997 |
4357 |
PrimaryInstructorLastName |
5493 |
4355 |
PrimaryInstructorType |
5980 |
5941 |
ReferenceNumber |
4950 |
4322 |
ReferenceNumberAK |
4949 |
4321 |
ScheduleInformation |
4995 |
4369 |
Session |
4985 |
4359 |
SessionCode |
4984 |
4358 |
Term |
4951 |
4323 |
TermCourseIdCount |
5983 |
5944 |
TermTitle |
4952 |
4324 |
TimeBlock |
4979 |
4351 |
TimeBlockCode |
4978 |
4350 |
VirtualCollege |
4991 |
4365 |
WebBlended |
4994 |
4368 |
WebEnabled |
4993 |
4367 |
WeekendCollege |
4987 |
4361 |
Output Columns
| Name | ID | LineageID |
ErrorCode |
4895 |
4895 |
ErrorColumn |
4896 |
4896 |
| Powered by BI Documenter |
