ssis.PackageConnection - U

type: U ( user table ), modify_date: 2022-09-05 18:18:08

RepoObject_guid: 5864FBE4-113B-EC11-852C-A81E8446D5B0

Description

Examples

Entity Diagram

entity-ssis.packageconnection

Columns

Table 1. Columns of ssis.PackageConnection - U
PK Column Name Data Type NULL? ID

1

varchar(50)

NOT NULL

2

varchar(200)

NOT NULL

3

uniqueidentifier

NOT NULL

varchar(max)

NULL

varchar(max)

NULL

varchar(max)

NULL

varchar(max)

NULL

nvarchar(max)

NULL

Definition (PERSISTED)
(case when [ConnectionManagerType]='FILE' AND right([ConnectionString],(5))='.dtsx' then substring([ConnectionString],(len([ConnectionString])-charindex('\',reverse([ConnectionString])))+(2),charindex('\',reverse([ConnectionString]))-(6))  end)

varchar(max)

NULL

Definition (PERSISTED)
(case when [ConnectionManagerType]='FILE' AND right([ConnectionString],(5))='.dtsx' then (1) else (0) end)

int

NOT NULL

Foreign Key Diagram

entity_1_1_fk-ssis.packageconnection

References

Referenced Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-ssis.packageconnection

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssis.packageconnection

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssis.packageconnection

Column Reference Diagram

entity_1_1_colref-ssis.packageconnection

Indexes

PK_PackageConnection

Column Details

_

AntoraModule

1

AntoraModule

varchar(50)

NOT NULL

PackageName

2

PackageName

varchar(200)

NOT NULL

ConnectionManagerID

3

ConnectionManagerID

uniqueidentifier

NOT NULL

ConnectionManagerName

ConnectionManagerName

varchar(max)

NULL

ExpressionValue

ExpressionValue

varchar(max)

NULL

RetainSameConnectionProperty

RetainSameConnectionProperty

nvarchar(max)

NULL

DtsPackageBaseName

DtsPackageBaseName

Definition (PERSISTED)
(case when [ConnectionManagerType]='FILE' AND right([ConnectionString],(5))='.dtsx' then substring([ConnectionString],(len([ConnectionString])-charindex('\',reverse([ConnectionString])))+(2),charindex('\',reverse([ConnectionString]))-(6))  end)

varchar(max)

NULL

Description

(case when [ConnectionManagerType]='FILE' AND right([ConnectionString],(5))='.dtsx' then substring([ConnectionString],(len([ConnectionString])-charindex('\',reverse([ConnectionString])))+(2),charindex('\',reverse([ConnectionString]))-(6)) end)


isFileAndDtsPackage

isFileAndDtsPackage

Definition (PERSISTED)
(case when [ConnectionManagerType]='FILE' AND right([ConnectionString],(5))='.dtsx' then (1) else (0) end)

int

NOT NULL

Description

(case when [ConnectionManagerType]='FILE' AND right([ConnectionString],(5))='.dtsx' then (1) else (0) end)