ssis.PackageTask_Dft_Component_tgt - V
type: V ( view ), modify_date: 2021-11-06 12:45:34
RepoObject_guid: B8DCAD7F-F73E-EC11-852D-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
1 |
|
|
||
2 |
|
|
||
3 |
|
|
||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Persistence, History Table
-
persistence source: ssis.PackageTask_Dft_Component_src - V
-
is_persistence: 1
-
is_persistence_check_duplicate_per_pk: 0
-
is_persistence_check_for_empty_source: 0
-
is_persistence_delete_changed: 0
-
is_persistence_delete_missing: 1
-
is_persistence_insert: 1
-
is_persistence_truncate: 0
-
is_persistence_update_changed: 1
-
has_history: 0
-
has_history_columns: 0
Indexes
PK_PackageTask_Dft_Component_tgt
-
IndexSemanticGroup: no_group
-
[column-AntoraModule]; varchar(50)
-
[column-PackageName]; varchar(200)
-
[column-Component_refId]; varchar(max)
-
-
PK, Unique, Real: 1, 1, 0
idx_PackageTask_Dft_Component_tgt__2
-
IndexSemanticGroup: no_group
-
PK, Unique, Real: 0, 0, 0
idx_PackageTask_Dft_Component_tgt__3
-
IndexSemanticGroup: no_group
-
[column-AntoraModule]; varchar(50)
-
[column-PackageName]; varchar(200)
-
-
PK, Unique, Real: 0, 0, 0
idx_PackageTask_Dft_Component_tgt__4
-
IndexSemanticGroup: no_group
-
[column-AntoraModule]; varchar(50)
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
sql_modules_definition
ssis.PackageTask_Dft_Component_tgt - V script
CREATE View [ssis].[PackageTask_Dft_Component_tgt]
As
Select
tgt.AntoraModule
, tgt.PackageName
, tgt.Component_refId
, tgt.Component_name
, tgt.Component_componentClassID
, tgt.Component_description
, tgt.Component_ContactInfo
, tgt.Component_CommandTimeout
, tgt.Component_OpenRowset
, tgt.Component_OpenRowsetVariable
, tgt.Component_SqlCommand
, tgt.Component_SqlCommandVariable
, tgt.Component_DefaultCodePage
, tgt.Component_AlwaysUseDefaultCodePage
, tgt.Component_AccessMode
, tgt.Component_ParameterMapping
, tgt.Component_FastLoadKeepIdentity
, tgt.Component_FastLoadKeepNulls
, tgt.Component_FastLoadOptions
, tgt.Component_FastLoadMaxInsertCommitSize
, tgt.Component_VariableName
, tgt.Component_Connection_refId
, tgt.Component_connectionManagerID
, tgt.Component_connectionManagerRefId
, tgt.Component_Connection_description
, tgt.Component_Connection_name
, tgt.Component_IsSortedProperty
, tgt.TaskPath
, tgt.ControlFlowDetailsRowID
From
ssis.PackageTask_Dft_Component As tgt
Where
Exists
(
Select
1
From
ssis.AntoraModule_tgt_filter As f
Where
tgt.AntoraModule = f.AntoraModule
)