ssis.PackageTask_Dft_Component - U

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

RepoObject_guid: B9DCAD7F-F73E-EC11-852D-A81E8446D5B0

Description

Examples

Entity Diagram

entity-ssis.packagetask_dft_component

Columns

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

varchar(50)

NOT NULL

varchar(max)

NULL

varchar(max)

NULL

int

NULL

varchar(max)

NULL

varchar(max)

NULL

varchar(max)

NULL

varchar(max)

NULL

varchar(max)

NULL

varchar(max)

NULL

varchar(max)

NULL

int

NULL

varchar(max)

NULL

bit

NULL

bit

NULL

int

NULL

varchar(max)

NULL

varchar(10)

NULL

varchar(max)

NOT NULL

varchar(max)

NULL

varchar(max)

NULL

varchar(max)

NULL

varchar(max)

NOT NULL

varchar(max)

NULL

varchar(max)

NULL

varchar(max)

NULL

int

NOT NULL

varchar(200)

NOT NULL

varchar(8000)

NOT NULL

Definition
(case when left([Component_connectionManagerRefId],(26))='Project.ConnectionManagers' OR left([Component_connectionManagerRefId],(26))='Package.ConnectionManagers' then substring([Component_connectionManagerRefId],(28),len([Component_connectionManagerRefId])-(28))  end)

varchar(max)

NULL

Definition (PERSISTED)
(replace([PackageName],'.dtsx',''))

varchar(8000)

NULL

Foreign Key Diagram

entity_1_1_fk-ssis.packagetask_dft_component

References

Object Reference Diagram - 1 1

entity_1_1_objectref-ssis.packagetask_dft_component

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssis.packagetask_dft_component

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssis.packagetask_dft_component

Column Reference Diagram

entity_1_1_colref-ssis.packagetask_dft_component

Column Details

_

Component_AccessMode

Component_AccessMode

varchar(max)

NULL

Component_AlwaysUseDefaultCodePage

Component_AlwaysUseDefaultCodePage

varchar(max)

NULL

Component_CommandTimeout

Component_CommandTimeout

int

NULL

Component_componentClassID

Component_componentClassID

varchar(max)

NULL

Component_Connection_description

Component_Connection_description

varchar(max)

NULL

Component_Connection_name

Component_Connection_name

varchar(max)

NULL

Component_Connection_refId

Component_Connection_refId

varchar(max)

NULL

Component_connectionManagerID

Component_connectionManagerID

varchar(max)

NULL

Component_connectionManagerRefId

Component_connectionManagerRefId

varchar(max)

NULL

Component_ContactInfo

Component_ContactInfo

varchar(max)

NULL

Component_DefaultCodePage

Component_DefaultCodePage

int

NULL

Component_description

Component_description

varchar(max)

NULL

Component_FastLoadKeepIdentity

Component_FastLoadKeepIdentity

bit

NULL

Component_FastLoadKeepNulls

Component_FastLoadKeepNulls

bit

NULL

Component_FastLoadMaxInsertCommitSize

Component_FastLoadMaxInsertCommitSize

int

NULL

Component_FastLoadOptions

Component_FastLoadOptions

varchar(max)

NULL

Component_IsSortedProperty

Component_IsSortedProperty

varchar(10)

NULL

Component_name

Component_name

varchar(max)

NOT NULL

Component_OpenRowset

Component_OpenRowset

varchar(max)

NULL

Component_OpenRowsetVariable

Component_OpenRowsetVariable

varchar(max)

NULL

Component_ParameterMapping

Component_ParameterMapping

varchar(max)

NULL

Component_refId

Component_refId

varchar(max)

NOT NULL

Component_SqlCommand

Component_SqlCommand

varchar(max)

NULL

Component_SqlCommandVariable

Component_SqlCommandVariable

varchar(max)

NULL

Component_VariableName

Component_VariableName

varchar(max)

NULL

ControlFlowDetailsRowID

ControlFlowDetailsRowID

int

NOT NULL

Component_ConnectionManagerName

Component_ConnectionManagerName

Definition
(case when left([Component_connectionManagerRefId],(26))='Project.ConnectionManagers' OR left([Component_connectionManagerRefId],(26))='Package.ConnectionManagers' then substring([Component_connectionManagerRefId],(28),len([Component_connectionManagerRefId])-(28))  end)

varchar(max)

NULL

Description

(case when left([Component_connectionManagerRefId],(26))='Project.ConnectionManagers' OR left([Component_connectionManagerRefId],(26))='Package.ConnectionManagers' then substring([Component_connectionManagerRefId],(28),len([Component_connectionManagerRefId])-(28)) end)


PackageBasename

PackageBasename

Definition (PERSISTED)
(replace([PackageName],'.dtsx',''))

varchar(8000)

NULL

Description

(replace([PackageName],'.dtsx',''))