ssis.PackageTask_LevelLagLead - V
type: V ( view ), modify_date: 2021-11-22 18:59:15
RepoObject_guid: BDDCAD7F-F73E-EC11-852D-A81E8446D5B0
Columns
| PK | Column Name | Data Type | NULL? | ID |
|---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Column Details
_
PackageBasename
PackageBasename |
|
|
Description
(replace([PackageName],'.dtsx',''))
Referenced Columns
TaskPathLevel
TaskPathLevel |
|
|
Description
(len([TaskPath])-len(replace([TaskPath],'\','')))
Referenced Columns
Referencing Columns
sql_modules_definition
ssis.PackageTask_LevelLagLead - V script
CREATE View ssis.PackageTask_LevelLagLead
As
Select
T1.AntoraModule
, T1.PackageName
, T1.TaskPath
, T1.TaskName
, T1.TaskPathLevel
, TaskPathLevelLag = Lag ( T1.TaskPathLevel ) Over ( Partition By T1.AntoraModule, T1.PackageName Order By T1.TaskPath )
, TaskPathLevelLead = Lead ( T1.TaskPathLevel ) Over ( Partition By T1.AntoraModule, T1.PackageName Order By T1.TaskPath )
, T1.TaskPathParent
, T1.TaskType
, T1.PackageBasename
From
ssis.PackageTask As T1