ssis.PackageTask_tgt - V

type: V ( view ), modify_date: 2021-11-01 16:53:53

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

Description

Examples

Entity Diagram

entity-ssis.packagetask_tgt

Columns

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

1

varchar(50)

NOT NULL

2

varchar(200)

NOT NULL

3

varchar(8000)

NOT 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)

NOT NULL

varchar(5000)

NULL

Persistence, History Table

  • persistence source: ssis.PackageTask_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

Foreign Key Diagram

entity_1_1_fk-ssis.packagetask_tgt

References

Object Reference Diagram - 1 1

entity_1_1_objectref-ssis.packagetask_tgt

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssis.packagetask_tgt

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssis.packagetask_tgt

Column Reference Diagram

entity_1_1_colref-ssis.packagetask_tgt

Indexes

PK_PackageTask_tgt

idx_PackageTask_tgt__2

idx_PackageTask_tgt__3

idx_PackageTask_tgt__4

Column Details

_

AntoraModule

1

AntoraModule

varchar(50)

NOT NULL

PackageName

2

PackageName

varchar(200)

NOT NULL

TaskPath

3

TaskPath

varchar(8000)

NOT NULL

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

Script

Script

varchar(max)

NULL

SqlConnection

SqlConnection

uniqueidentifier

NULL

SqlStatementSource

SqlStatementSource

nvarchar(max)

NULL

TaskDescription

TaskDescription

varchar(max)

NULL

TaskName

TaskName

varchar(2000)

NOT NULL

TaskType

TaskType

varchar(5000)

NULL

sql_modules_definition

ssis.PackageTask_tgt - V script
CREATE VIEW [ssis].[PackageTask_tgt]
As
Select
    tgt.AntoraModule
  , tgt.PackageName
  , tgt.TaskPath
  , tgt.TaskName
  , tgt.ControlFlowDetailsRowID
  , tgt.TaskDescription
  , tgt.TaskType
  , tgt.IsDisabled
  , tgt.DelayValidationPropertyValue
  --, tgt.DFTQuery
  --, tgt.SqlTaskQry
  --, tgt.ExecPkgTaskQry
  --, tgt.ScriptTaskQry
  , tgt.ExpressionValue
  , tgt.Script
  , tgt.SqlConnection
  , tgt.SqlStatementSource
  , tgt.ExecutePackageExpression
  , tgt.ExecutedPackageName
  , tgt.ExecutePackageConnection
From
    ssis.PackageTask As tgt
Where
    Exists
(
    Select
        1
    From
        ssis.AntoraModule_tgt_filter As f
    Where
        tgt.AntoraModule = f.AntoraModule
)