DimUserLoad
 OLE_SRC Temp Tables for ZipCounty (Component)
  Properties
Property Value
Name OLE_SRC Temp Tables for ZipCounty
Description OLE DB Source
Up Stream Components none
Down Stream Components
ID 3553
Component Class ID {BCEFE59B-6819-47F7-A125-63753B33ABB7}
Contact Info OLE DB Source;Microsoft Corporation; Microsoft SqlServer v10; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;7
Identification String component "OLE_SRC Temp Tables for ZipCounty" (3553)
Is Default Locale True
Pipeline Version 0
Uses Dispositions True
Validate External Metadata True
Version 7
  Connections
Name Connection Manager Description
OleDbConnection
  Custom Properties
Name Value
AccessMode
2
AlwaysUseDefaultCodePage
False
CommandTimeout
0
DefaultCodePage
1252
OpenRowset
OpenRowsetVariable
ParameterMapping
SqlCommand
SELECT VerifyZipCountySK
      ,ZipCodeAK
      ,ZipCode
      ,CountyFIPS
      ,County
      ,City
      ,State
  FROM Verify_dbo_DimZipCounty
  Where RowIsSelected = 'Y'
  Order BY ZipCodeAK
SqlCommandVariable
User::GetCurriculumMods
  Input Columns
Name ID LineageID
  Output Columns
Name ID LineageID
City
7527
7527
County
7524
7524
CountyFIPS
7521
7521
ErrorCode
3565
3565
ErrorColumn
3566
3566
State
7530
7530
VerifyZipCountySK
7512
7512
ZipCode
7518
7518
ZipCodeAK
7515
7515
City
7526
7526
County
7523
7523
CountyFIPS
7520
7520
State
7529
7529
VerifyZipCountySK
7511
7511
ZipCode
7517
7517
ZipCodeAK
7514
7514
Powered by BI Documenter