|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Name | OLE_DST Load New Temp Table for Curriculum |
| Description | OLE DB Destination |
| Up Stream Components | |
| Down Stream Components | none |
| ID | 4581 |
| 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 Curriculum" (4581) |
| 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_DimCurriculum__New] |
OpenRowsetVariable |
|
SqlCommand |
Input Columns
| Name | ID | LineageID |
Apprenticeship |
4743 |
4256 |
Campus |
4722 |
4235 |
CampusCode |
4721 |
4234 |
Center |
4724 |
4237 |
CenterCode |
4723 |
4236 |
ClassStatus |
4728 |
4241 |
ClassStatusCode |
4727 |
4240 |
ClassTitle |
4659 |
4221 |
CourseId |
4705 |
4217 |
CourseIdPrefix |
4708 |
4220 |
CourseLevel |
6220 |
6205 |
CourseNumberTimesForCredit |
6000 |
5931 |
CourseType |
4710 |
4223 |
CourseTypeCode |
4709 |
4222 |
CreditNonCredit |
4714 |
4227 |
CreditNonCreditVocational |
4711 |
4224 |
CreditNonCreditVocationalTest |
6357 |
6348 |
CreditType |
4713 |
4226 |
CreditTypeCode |
4712 |
4225 |
CurrentCourseId |
4707 |
4219 |
CurrentTerm |
4706 |
4218 |
DeliveryMethod |
4731 |
4244 |
Department |
4720 |
4233 |
DepartmentCode |
4719 |
4232 |
DepartmentDescription |
6451 |
6433 |
Division |
4718 |
4231 |
DivisionCode |
4717 |
4230 |
DivisionDescription |
6450 |
6432 |
DualEnrollment |
4741 |
4254 |
Honors |
4739 |
4252 |
ICSCategoryCode |
5995 |
5926 |
ICSCode |
4715 |
4228 |
IndependentStudy |
4742 |
4255 |
InstructionalClassification |
4716 |
4229 |
InstructionalClassificationCategory |
5996 |
5927 |
IsCourseRepeatable |
6096 |
6072 |
IsTermCourseIdCountGE10 |
6095 |
6071 |
MaximumClassSize |
4726 |
4239 |
MinimumClassSize |
4725 |
4238 |
Online100Percent |
4745 |
4258 |
PrimaryInstructor |
4732 |
4245 |
PrimaryInstructorFirstName |
4735 |
4248 |
PrimaryInstructorFullName |
4733 |
4246 |
PrimaryInstructorInitial |
4736 |
4249 |
PrimaryInstructorLastName |
5491 |
4247 |
PrimaryInstructorType |
5994 |
5925 |
ReferenceNumber |
4702 |
4214 |
ReferenceNumberAK |
4703 |
4213 |
RowEndDate |
4751 |
4264 |
RowIsCurrent |
4749 |
4262 |
RowStartDate |
4750 |
4263 |
ScheduleInformation |
4748 |
4261 |
Session |
4738 |
4251 |
SessionCode |
4737 |
4250 |
Term |
4704 |
4215 |
TermCourseIdCount |
5997 |
5928 |
TermTitle |
4654 |
4216 |
TimeBlock |
4730 |
4243 |
TimeBlockCode |
4729 |
4242 |
VirtualCollege |
4744 |
4257 |
WebBlended |
4747 |
4260 |
WebEnabled |
4746 |
4259 |
WeekendCollege |
4740 |
4253 |
Output Columns
| Name | ID | LineageID |
ErrorCode |
4596 |
4596 |
ErrorColumn |
4597 |
4597 |
| Powered by BI Documenter |
