DimCheckTypeLoad
 OLE_SRC Verification Temp table from UTL_CODE_TABLE_A Staging (Component)
  Properties
Property Value
Name OLE_SRC Verification Temp table from UTL_CODE_TABLE_A Staging
Description OLE DB Source
Up Stream Components none
Down Stream Components
ID 1
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 Verification Temp table from UTL_CODE_TABLE_A Staging" (1)
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
  CAST(CODE AS VARCHAR(3)) AS CheckTypeAK
 ,CAST(CODE AS VARCHAR(3)) AS CheckTypeCode
 ,CAST(DESCRIPTION AS VARCHAR(30)) AS CheckType
FROM UTL_CODE_TABLE CheckT
WHERE TABLE_NAME = 'CHECK-TYPE'
AND STATUS = 'A'
UNION ALL
SELECT
  CAST(CODE AS VARCHAR(3)) AS CheckTypeAK
 ,CAST(CODE AS VARCHAR(3)) AS CheckTypeCode
 ,CAST(DESCRIPTION AS VARCHAR(30)) AS CheckType
FROM UTL_CODE_TABLE CheckT
WHERE TABLE_NAME = 'CHECK-TYPE'
AND STATUS <> 'A'
UNION ALL
SELECT
  CAST('MO' AS VARCHAR(3)) AS CheckTypeAK
 ,CAST('MO' AS VARCHAR(3)) AS CheckTypeCode
 ,CAST('MONTHLY BENEFIT' AS VARCHAR(30)) AS CheckType
SqlCommandVariable
User::GetPositionMods
  Input Columns
Name ID LineageID
  Output Columns
Name ID LineageID
CheckType
3016
3016
CheckTypeAK
3010
3010
CheckTypeCode
3013
3013
ErrorCode
13
13
ErrorColumn
14
14
CheckType
3015
3015
CheckTypeAK
3009
3009
CheckTypeCode
3012
3012
Powered by BI Documenter