ssis.PackageTask_Sql_Parameter_src - V

type: V ( view ), modify_date: 2021-11-01 14:44:38

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

Description

Examples

Entity Diagram

entity-ssis.packagetask_sql_parameter_src

Columns

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

1

varchar(50)

NOT NULL

2

varchar(200)

NULL

3

varchar(8000)

NULL

4

varchar(1000)

NULL

int

NOT NULL

varchar(1000)

NULL

varchar(1000)

NULL

Foreign Key Diagram

entity_1_1_fk-ssis.packagetask_sql_parameter_src

References

Object Reference Diagram - 1 1

entity_1_1_objectref-ssis.packagetask_sql_parameter_src

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssis.packagetask_sql_parameter_src

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssis.packagetask_sql_parameter_src

Column Reference Diagram

entity_1_1_colref-ssis.packagetask_sql_parameter_src

Indexes

PK_PackageTask_Sql_Parameter_src

idx_PackageTask_Sql_Parameter_src__2

idx_PackageTask_Sql_Parameter_src__3

idx_PackageTask_Sql_Parameter_src__4

Column Details

_

AntoraModule

1

AntoraModule

varchar(50)

NOT NULL

Referenced Columns

PackageName

2

PackageName

varchar(200)

NULL

Description

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


Referenced Columns

TaskPath

3

TaskPath

varchar(8000)

NULL

Referenced Columns

ParameterBindingSequence

4

ParameterBindingSequence

varchar(1000)

NULL

ControlFlowDetailsRowID

ControlFlowDetailsRowID

int

NOT NULL

ParameterBindingParameterName

ParameterBindingParameterName

varchar(1000)

NULL

ResultSetParameterName

ResultSetParameterName

varchar(1000)

NULL

sql_modules_definition

ssis.PackageTask_Sql_Parameter_src - V script
--todo:
--hier fehlt das eigentliche Skipt
--ssis_t.TblSQLTaskDetails enthält nur die n:1 Details wie ParameterBinding
--es gibt noch die Daten zum eigentlichen SQL Task XML [SqlTaskQry]
--das muss noch separat bestimmt werden
--entweder in der Granularität von ssis_t.TblControlFlowDetails
--oder als separate Sicht ssis.PackageTaskSql_src
CREATE View [ssis].[PackageTask_Sql_Parameter_src]
As
Select
    p.AntoraModule
  , p.PackageName
  , T2.TaskPath
  , T3.ParameterBindingSequence
  , T3.ResultSetParameterName
  , T3.ParameterBindingParameterName
  , 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_Sql_Parameter As T3
            On
            T3.ControlFlowDetailsRowID = T2.ControlFlowDetailsRowID
Where
    Not T3.ParameterBindingSequence Is Null