docs.ssis_PumlPartialDftComponent - V

type: V ( view ), modify_date: 2021-11-09 16:44:27

RepoObject_guid: 69DDD159-FC3E-EC11-852D-A81E8446D5B0

Description

Examples

Entity Diagram

entity-docs.ssis_pumlpartialdftcomponent

Columns

Table 1. Columns of docs.ssis_PumlPartialDftComponent - V
PK Column Name Data Type NULL? ID

varchar(50)

NOT NULL

varchar(max)

NOT NULL

varchar(max)

NOT NULL

varchar(200)

NOT NULL

nvarchar(max)

NULL

varchar(8000)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-docs.ssis_pumlpartialdftcomponent

References

Object Reference Diagram - 1 1

entity_1_1_objectref-docs.ssis_pumlpartialdftcomponent

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-docs.ssis_pumlpartialdftcomponent

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-docs.ssis_pumlpartialdftcomponent

Column Reference Diagram

entity_1_1_colref-docs.ssis_pumlpartialdftcomponent

Column Details

_

AntoraModule

AntoraModule

varchar(50)

NOT NULL

Component_name

Component_name

varchar(max)

NOT NULL

Component_refId

Component_refId

varchar(max)

NOT NULL

PackageName

PackageName

varchar(200)

NOT NULL

PumlPartialDftComponent

PumlPartialDftComponent

nvarchar(max)

NULL

TaskPath

TaskPath

varchar(8000)

NOT NULL

sql_modules_definition

docs.ssis_PumlPartialDftComponent - V script
CREATE View [docs].[ssis_PumlPartialDftComponent]
As
Select
    AntoraModule
  , PackageName
  , TaskPath
  , Component_refId
  , Component_name
  , PumlPartialDftComponent =
  --
  '  component "' + Component_name + '" as ' + docs.fs_cleanStringForAnchorId ( Component_refId )
  --hyperlink:
  --+ ' [[#dftcomponent-' + docs.fs_cleanStringForAnchorId ( Component_refId ) + ']]'
  + ' [[../' + docs.fs_cleanStringForFilename ( PackageBasename ) + '.html#dftcomponent-'
  + docs.fs_cleanStringForAnchorId ( Component_refId ) + ']]'
From
    ssis.PackageTask_Dft_Component