DimUserLoad
 OLE_DEST Load Verification table ZipCounty (Component)
  Properties
Property Value
Name OLE_DEST Load Verification table ZipCounty
Description OLE DB Destination
Up Stream Components
Down Stream Components none
ID 1745
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_DEST Load Verification table ZipCounty" (1745)
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].[Verify_dbo_DimZipCounty]
OpenRowsetVariable
SqlCommand
  Input Columns
Name ID LineageID
City
2255
2233
County
2254
2230
CountyFIPS
2253
2227
RowIsDuplicate
2045
552
RowIsSelected
2046
555
State
2256
2236
ZipCode
2252
2224
ZipCodeAK
2251
2221
  Output Columns
Name ID LineageID
ErrorCode
1760
1760
ErrorColumn
1761
1761
Powered by BI Documenter