ssis.PackageTask_Dft_Component_src - V
type: V ( view ), modify_date: 2021-11-06 12:44:33
RepoObject_guid: B7DCAD7F-F73E-EC11-852D-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
1 |
|
|
||
2 |
|
|
||
3 |
|
|
||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
PK_PackageTask_Dft_Component_src
-
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_src__2
-
IndexSemanticGroup: no_group
-
PK, Unique, Real: 0, 0, 0
idx_PackageTask_Dft_Component_src__3
-
IndexSemanticGroup: no_group
-
[column-AntoraModule]; varchar(50)
-
[column-PackageName]; varchar(200)
-
-
PK, Unique, Real: 0, 0, 0
idx_PackageTask_Dft_Component_src__4
-
IndexSemanticGroup: no_group
-
[column-AntoraModule]; varchar(50)
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
PackageName
2 |
PackageName |
|
|
(left(replace([PackagePath],[ProjectPath]+'\',''),(200)))
Component_AlwaysUseDefaultCodePage
Component_AlwaysUseDefaultCodePage |
|
|
Component_componentClassID
Component_componentClassID |
|
|
Component_Connection_description
Component_Connection_description |
|
|
Component_Connection_name
Component_Connection_name |
|
|
Component_Connection_refId
Component_Connection_refId |
|
|
Component_connectionManagerID
Component_connectionManagerID |
|
|
Component_connectionManagerRefId
Component_connectionManagerRefId |
|
|
Component_ContactInfo
Component_ContactInfo |
|
|
Component_description
Component_description |
|
|
Component_FastLoadKeepIdentity
Component_FastLoadKeepIdentity |
|
|
Component_FastLoadKeepNulls
Component_FastLoadKeepNulls |
|
|
Component_FastLoadMaxInsertCommitSize
Component_FastLoadMaxInsertCommitSize |
|
|
Component_FastLoadOptions
Component_FastLoadOptions |
|
|
Component_IsSortedProperty
Component_IsSortedProperty |
|
|
Component_OpenRowsetVariable
Component_OpenRowsetVariable |
|
|
Component_ParameterMapping
Component_ParameterMapping |
|
|
Component_SqlCommandVariable
Component_SqlCommandVariable |
|
|
Component_VariableName
Component_VariableName |
|
|
sql_modules_definition
ssis.PackageTask_Dft_Component_src - V script
CREATE View [ssis].[PackageTask_Dft_Component_src]
As
Select
p.AntoraModule
, p.PackageName
, Component_refId = T3.refId
, Component_name = T3.name
, Component_componentClassID = T3.componentClassID
, Component_description = T3.description
, Component_ContactInfo = T3.ContactInfo
, Component_CommandTimeout = T3.CommandTimeout
, Component_OpenRowset = T3.[OpenRowset]
, Component_OpenRowsetVariable = T3.OpenRowsetVariable
, Component_SqlCommand = T3.SqlCommand
, Component_SqlCommandVariable = T3.SqlCommandVariable
, Component_DefaultCodePage = T3.DefaultCodePage
, Component_AlwaysUseDefaultCodePage = T3.AlwaysUseDefaultCodePage
, Component_AccessMode = T3.AccessMode
, Component_ParameterMapping = T3.ParameterMapping
, Component_FastLoadKeepIdentity = T3.FastLoadKeepIdentity
, Component_FastLoadKeepNulls = T3.FastLoadKeepNulls
, Component_FastLoadOptions = T3.FastLoadOptions
, Component_FastLoadMaxInsertCommitSize = T3.FastLoadMaxInsertCommitSize
, Component_VariableName = T3.VariableName
, Component_Connection_refId = T3.Connection_refId
, Component_connectionManagerID = T3.connectionManagerID
, Component_connectionManagerRefId = T3.connectionManagerRefId
, Component_Connection_description = T3.Connection_description
, Component_Connection_name = T3.Connection_name
, Component_IsSortedProperty = T3.IsSortedProperty
, T2.TaskPath
, T2.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 As T3
On
T3.ControlFlowDetailsRowID = T2.ControlFlowDetailsRowID