DimUserLoad
 OLE_DST Load New Temp table for ZipCounty (Component)
  Properties
Property Value
Name OLE_DST Load New Temp table for ZipCounty
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 ZipCounty" (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_DimZipCounty__New]
OpenRowsetVariable
SqlCommand
  Input Columns
Name ID LineageID
City
7661
7593
County
7660
7592
CountyFIPS
7659
7591
RowEndDate
7268
6950
RowIsCurrent
7266
6948
RowStartDate
7267
6949
State
7662
7594
ZipCode
7658
7590
ZipCodeAK
7657
7589
  Output Columns
Name ID LineageID
ErrorCode
7204
7204
ErrorColumn
7205
7205
Powered by BI Documenter