|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Name | OLE_DST Load New Temp table for Employee |
| Description | OLE DB Destination |
| Up Stream Components | |
| Down Stream Components | none |
| ID | 7189 |
| 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 Employee" (7189) |
| 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_DimEmployee__New] |
OpenRowsetVariable |
|
SqlCommand |
Input Columns
| Name | ID | LineageID |
Citizenship |
9253 |
8915 |
CitizenshipCode |
9252 |
8914 |
Country |
9251 |
8913 |
CountryCode |
9250 |
8912 |
CountryOfCitizenship |
9255 |
8917 |
CountryOfCitizenshipCode |
9254 |
8916 |
County |
9249 |
8911 |
CountyFIPSCode |
9248 |
8910 |
DateOfBirth |
9337 |
9320 |
EmployeeAK |
9233 |
8895 |
EmployeeFulltimeParttime |
9265 |
8927 |
EmployeeStudentId |
9262 |
8924 |
EmployeeType |
9236 |
8898 |
EmployeeTypeCode |
9235 |
8897 |
Ethnicity |
9244 |
8906 |
EthnicityCode |
9243 |
8905 |
FirstName |
9239 |
8901 |
FullName |
9237 |
8899 |
FunctionCode |
8463 |
8212 |
FunctionDesc |
9260 |
8922 |
Gender |
9242 |
8904 |
GenderCode |
9241 |
8903 |
HasActiveAssignment |
9256 |
8918 |
HasDirectDeposit |
9263 |
8925 |
HireDate |
9264 |
8926 |
IsAStudent |
9261 |
8923 |
LastActiveAssignmentDateRange |
9258 |
8920 |
LastName |
9238 |
8900 |
LastPayCheckDateRange |
9259 |
8921 |
Location |
9429 |
9403 |
LocationCode |
9428 |
9402 |
MiddleInitial |
9240 |
8902 |
NumberOfActiveAssignments |
9257 |
8919 |
PersonID |
9234 |
8896 |
PositionType |
8462 |
8211 |
PositionTypeCode |
8461 |
8210 |
PrimarySalaryAccountNumber |
8476 |
8225 |
RowEndDate |
7699 |
7691 |
RowIsCurrent |
7697 |
7667 |
RowStartDate |
7698 |
7683 |
State |
9246 |
8908 |
StateCode |
9245 |
8907 |
TerminationDate |
9266 |
8928 |
TerminationDateRange |
9267 |
8929 |
YearsOfServiceToInstitution |
9268 |
8930 |
ZipCode |
9247 |
8909 |
Output Columns
| Name | ID | LineageID |
ErrorCode |
7204 |
7204 |
ErrorColumn |
7205 |
7205 |
| Powered by BI Documenter |
