docs.ssis_DftTaskComponentInputList - V
type: V ( view ), modify_date: 2021-11-08 14:48:58
RepoObject_guid: CE246838-9F41-EC11-852D-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Column Details
sql_modules_definition
docs.ssis_DftTaskComponentInputList - V script
CREATE View docs.ssis_DftTaskComponentInputList
As
Select
T1.AntoraModule
, T1.PackageName
, T1.TaskPath
, T1.Component_refId
, DftTaskComponentInputList =
--
String_Agg (
Concat (
Cast(N'' As NVarchar(Max))
, '[#dftcomponentinput-'
, docs.fs_cleanStringForAnchorId ( T1.input_refId )
, ']' + Char ( 13 ) + Char ( 10 )
--
, '[discrete]' + Char ( 13 ) + Char ( 10 )
, '===== Input: '
, docs.fs_cleanStringForHeader ( T1.input_name )
, Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
----begin collapsible
--, '.Input: ' + docs.fs_cleanStringForHeader ( T1.input_name ) + Char ( 13 ) + Char ( 10 )
--, '[%collapsible]' + Char ( 13 ) + Char ( 10 )
--, '=======' + Char ( 13 ) + Char ( 10 )
--table start
, '.' + T1.input_refId + Char ( 13 ) + Char ( 10 )
, '[cols="1,4l"]' + Char ( 13 ) + Char ( 10 )
, '|===' + Char ( 13 ) + Char ( 10 )
, Char ( 13 ) + Char ( 10 )
--table content
--, '|' + 'input_refId' + Char ( 13 ) + Char ( 10 ) + '|' + T1.input_refId + Char ( 13 )
-- + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
, Iif(T1.input_errorOrTruncationOperation <> ''
, '|' + 'input_errorOrTruncationOperation' + Char ( 13 ) + Char ( 10 ) + '|'
+ T1.input_errorOrTruncationOperation + Char ( 13 ) + Char ( 10 ) + Char ( 13 )
+ Char ( 10 )
, '')
, Iif(T1.input_errorOrTruncationOperation <> ''
, '|' + 'input_errorRowDisposition' + Char ( 13 ) + Char ( 10 ) + '|'
+ T1.input_errorRowDisposition + Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
, '')
, Iif(Not T1.input_hasSideEffects Is Null
, '|' + 'input_hasSideEffects' + Char ( 13 ) + Char ( 10 ) + '|'
+ Cast(T1.input_hasSideEffects As Varchar(10)) + Char ( 13 ) + Char ( 10 )
+ Char ( 13 ) + Char ( 10 )
, '')
--table end
, '|===' + Char ( 13 ) + Char ( 10 )
, Char ( 13 ) + Char ( 10 ) + T2.DftTaskComponentInputColumnList + Char ( 13 ) + Char ( 10 )
----end collapsible
--, '=======' + Char ( 13 ) + Char ( 10 )
)
, Char ( 13 ) + Char ( 10 )
) Within Group(Order By
T1.input_refId)
From
ssis.PackageTask_Dft_Component_input As T1
Left Join
docs.ssis_DftTaskComponentInputColumnList As T2
On
T2.AntoraModule = T1.AntoraModule
And T2.PackageName = T1.PackageName
And T2.TaskPath = T1.TaskPath
And T2.Component_refId = T1.Component_refId
And T2.input_refId = T1.input_refId
Group By
T1.AntoraModule
, T1.PackageName
, T1.TaskPath
, T1.Component_refId