ssis.PackageTask_src - V

type: V ( view ), modify_date: 2021-11-01 15:36:00

RepoObject_guid: 6C64FBE4-113B-EC11-852C-A81E8446D5B0

Description

Examples

Entity Diagram

entity-ssis.packagetask_src

Columns

Table 1. Columns of ssis.PackageTask_src - V
PK Column Name Data Type NULL? ID

1

varchar(50)

NOT NULL

2

varchar(200)

NULL

3

varchar(8000)

NULL

int

NOT NULL

varchar(100)

NULL

varchar(1000)

NULL

varchar(1000)

NULL

varchar(1000)

NULL

varchar(5000)

NULL

varchar(10)

NULL

varchar(max)

NULL

uniqueidentifier

NULL

nvarchar(max)

NULL

varchar(max)

NULL

varchar(2000)

NULL

varchar(5000)

NULL

Foreign Key Diagram

entity_1_1_fk-ssis.packagetask_src

References

Object Reference Diagram - 1 1

entity_1_1_objectref-ssis.packagetask_src

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssis.packagetask_src

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssis.packagetask_src

Column Reference Diagram

entity_1_1_colref-ssis.packagetask_src

Indexes

PK_PackageTask_src

idx_PackageTask_src__2

idx_PackageTask_src__3

idx_PackageTask_src__4

Column Details

_

AntoraModule

1

AntoraModule

varchar(50)

NOT NULL

Referenced Columns
Referencing Columns

PackageName

2

PackageName

varchar(200)

NULL

Description

(left(replace([PackagePath],[ProjectPath]+'\',''),(200)))


Referenced Columns
Referencing Columns

TaskPath

3

TaskPath

varchar(8000)

NULL

Referenced Columns
Referencing Columns

ControlFlowDetailsRowID

ControlFlowDetailsRowID

int

NOT NULL

DelayValidationPropertyValue

DelayValidationPropertyValue

varchar(100)

NULL

ExecutedPackageName

ExecutedPackageName

varchar(1000)

NULL

ExecutePackageConnection

ExecutePackageConnection

varchar(1000)

NULL

ExecutePackageExpression

ExecutePackageExpression

varchar(1000)

NULL

ExpressionValue

ExpressionValue

varchar(5000)

NULL

IsDisabled

IsDisabled

varchar(10)

NULL

Referencing Columns

Script

Script

varchar(max)

NULL

Referenced Columns
Referencing Columns

SqlConnection

SqlConnection

uniqueidentifier

NULL

SqlStatementSource

SqlStatementSource

nvarchar(max)

NULL

TaskDescription

TaskDescription

varchar(max)

NULL

TaskName

TaskName

varchar(2000)

NULL

Referenced Columns
Referencing Columns

TaskType

TaskType

varchar(5000)

NULL

Referenced Columns
Referencing Columns

sql_modules_definition

ssis.PackageTask_src - V script
CREATE View ssis.PackageTask_src
As
Select
    p.AntoraModule
  , p.PackageName
  , T2.TaskPath
  , T2.TaskName
  , T2.ControlFlowDetailsRowID
  , T2.TaskDescription
  , T2.TaskType
  , T2.IsDisabled
  , T2.DelayValidationPropertyValue
  ---- The XML data type cannot be compared or sorted, except when using the IS NULL operator.
  --, T2.DFTQuery
  --, T2.SqlTaskQry
  --, T2.ExecPkgTaskQry
  --, T2.ScriptTaskQry
  , T2.ExpressionValue
  , T3.Script
  , T4.SqlConnection
  , T4.SqlStatementSource
  , T5.ExecutePackageExpression
  , T5.ExecutedPackageName
  , T5.ExecutePackageConnection
From
    ssis.Package_src                  As p
    Inner Join
        ssis_t.TblControlFlow         As T2
            On
            p.RowID                    = T2.RowID

    Left Outer Join
        ssis_t.TblTask_Script         As T3
            On
            T3.ControlFlowDetailsRowID = T2.ControlFlowDetailsRowID

    Left Outer Join
        ssis_t.TblTask_Sql            As T4
            On
            T4.ControlFlowDetailsRowID = T2.ControlFlowDetailsRowID

    Left Outer Join
        ssis_t.TblTask_ExecutePackage As T5
            On
            T5.ControlFlowDetailsRowID = T2.ControlFlowDetailsRowID