ssis.ProjectConnection_src - V

type: V ( view ), modify_date: 2021-11-04 09:23:17

RepoObject_guid: 829A07F7-C23C-EC11-852D-A81E8446D5B0

Description

Examples

Entity Diagram

entity-ssis.projectconnection_src

Columns

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

1

varchar(50)

NOT NULL

2

uniqueidentifier

NULL

varchar(max)

NULL

varchar(max)

NULL

varchar(8000)

NOT NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

Foreign Key Diagram

entity_1_1_fk-ssis.projectconnection_src

References

Object Reference Diagram - 1 1

entity_1_1_objectref-ssis.projectconnection_src

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssis.projectconnection_src

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssis.projectconnection_src

Column Reference Diagram

entity_1_1_colref-ssis.projectconnection_src

Indexes

PK_ProjectConnection_src

idx_ProjectConnection_src__2

Column Details

_

AntoraModule

1

AntoraModule

varchar(50)

NOT NULL

Referenced Columns

ConnectionManagerID

2

ConnectionManagerID

uniqueidentifier

NULL

ConnectionManagerName

ConnectionManagerName

varchar(max)

NULL

ConnectionManagerType

ConnectionManagerType

varchar(max)

NULL

ConnectionPath

ConnectionPath

varchar(8000)

NOT NULL

ConnectionString

ConnectionString

nvarchar(max)

NULL

ExpressionValue

ExpressionValue

nvarchar(max)

NULL

sql_modules_definition

ssis.ProjectConnection_src - V script
CREATE View ssis.ProjectConnection_src
As
Select
    proj.AntoraModule
  , T2.ConnectionManagerID
  , T2.ConnectionManagerName AS ConnectionManagerName
  , T2.ConnectionManagerType
  , pc.ConnectionPath
  , T2.ConnectionString
  , T2.ExpressionValue
From
    ssis_t.ProjectConnection        As pc
    Inner Join
        ssis.Project                As proj
            On
            pc.ProjectPath = proj.ProjectPath

    Inner Join
        ssis_t.TblProjectConnection As T2
            On
            pc.RowID       = T2.RowID