|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Name | OLE_DST Temp New Term |
| Description | OLE DB Destination |
| Up Stream Components | |
| Down Stream Components | none |
| ID | 875 |
| 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 Temp New Term" (875) |
| 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_DimTerm__New] |
OpenRowsetVariable |
|
SqlCommand |
Input Columns
| Name | ID | LineageID |
AcademicYear |
1274 |
1158 |
AcademicYearCode |
1273 |
1157 |
ActiveTerm |
1278 |
1162 |
DefaultTerm |
1279 |
1163 |
PriorYearTerm |
1280 |
1164 |
RelativeDay |
1384 |
1376 |
RowEndDate |
1283 |
1167 |
RowIsCurrent |
1281 |
1165 |
RowStartDate |
1282 |
1166 |
StateReportingTermSequence |
1560 |
1544 |
StateReportingTermYear |
1559 |
1543 |
TermAK |
1269 |
1153 |
TermEndDate |
1271 |
1155 |
TermSK |
1268 |
1152 |
TermStartDate |
1270 |
1154 |
TermTitle |
1272 |
1156 |
TermType |
1277 |
1161 |
TermTypeCode |
1276 |
1160 |
TermYear |
1275 |
1159 |
Output Columns
| Name | ID | LineageID |
ErrorCode |
890 |
890 |
ErrorColumn |
891 |
891 |
| Powered by BI Documenter |
