ssis.PackageTask_Dft_Component_input_externalMetadataColumn_src - V
type: V ( view ), modify_date: 2021-11-07 14:31:08
RepoObject_guid: 7BCC7FC6-CF3F-EC11-852D-A81E8446D5B0
Columns
| PK | Column Name | Data Type | NULL? | ID |
|---|---|---|---|---|
1 |
|
|
||
2 |
|
|
||
3 |
|
|
||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
PK_PackageTask_Dft_Component_input_externalMetadataColumn_src
-
IndexSemanticGroup: no_group
-
[column-AntoraModule]; varchar(50)
-
[column-PackageName]; varchar(200)
-
[column-Column_refId]; varchar(max)
-
-
PK, Unique, Real: 1, 1, 0
idx_PackageTask_Dft_Component_input_externalMetadataColumn_src__2
-
IndexSemanticGroup: no_group
-
[column-AntoraModule]; varchar(50)
-
[column-PackageName]; varchar(200)
-
-
PK, Unique, Real: 0, 0, 0
idx_PackageTask_Dft_Component_input_externalMetadataColumn_src__3
-
IndexSemanticGroup: no_group
-
[column-AntoraModule]; varchar(50)
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
PackageName
2 |
PackageName |
|
|
(left(replace([PackagePath],[ProjectPath]+'\',''),(200)))
input_errorOrTruncationOperation
input_errorOrTruncationOperation |
|
|
sql_modules_definition
ssis.PackageTask_Dft_Component_input_externalMetadataColumn_src - V script
Create View ssis.PackageTask_Dft_Component_input_externalMetadataColumn_src
As
Select
p.AntoraModule
, p.PackageName
, Component_refId = T3.refId
, T3.input_refId
, T3.input_errorOrTruncationOperation
, T3.input_errorRowDisposition
, T3.input_hasSideEffects
, T3.input_name
, T3.externalMetadataColumns_isused
, T3.Column_refId
, T3.Column_name
, T3.Column_dataType
, T3.Column_length
, T3.Column_precision
, T3.Column_scale
, T2.TaskPath
, T3.ControlFlowDetailsRowID
From
ssis.Package_src As p
Inner Join
ssis_t.TblControlFlow As T2
On
p.RowID = T2.RowID
Inner Join
ssis_t.TblTask_Dft_Component_inputs_externalMetadataColumn_src As T3
On
T3.ControlFlowDetailsRowID = T2.ControlFlowDetailsRowID