ssis.PackageConnection_src - V
type: V ( view ), modify_date: 2021-11-01 14:14:06
RepoObject_guid: 5964FBE4-113B-EC11-852C-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
1 |
|
|
||
2 |
|
|
||
3 |
|
|
||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
PK_PackageConnection_src
-
IndexSemanticGroup: no_group
-
[column-AntoraModule]; varchar(50)
-
[column-PackageName]; varchar(200)
-
[column-ConnectionManagerID]; uniqueidentifier
-
-
PK, Unique, Real: 1, 1, 0
idx_PackageConnection_src__2
-
IndexSemanticGroup: no_group
-
[column-AntoraModule]; varchar(50)
-
[column-PackageName]; varchar(200)
-
-
PK, Unique, Real: 0, 0, 0
idx_PackageConnection_src__3
-
IndexSemanticGroup: no_group
-
[column-AntoraModule]; varchar(50)
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
PackageName
2 |
PackageName |
|
|
(left(replace([PackagePath],[ProjectPath]+'\',''),(200)))
ConnectionManagerID
3 |
ConnectionManagerID |
|
|
ConnectionManagerName
ConnectionManagerName |
|
|
ConnectionManagerType
ConnectionManagerType |
|
|
sql_modules_definition
ssis.PackageConnection_src - V script
CREATE View [ssis].[PackageConnection_src]
As
Select
p.AntoraModule
, p.PackageName
, T2.ConnectionManagerID
, T2.ConnectionManagerName
, T2.ConnectionManagerType
, T2.ConnectionString
, T2.ExpressionValue
, T2.RetainSameConnectionProperty
From
ssis.Package_src As p
Inner Join
ssis_t.TblConnection As T2
On
p.RowID = T2.RowID