ssis_t.PackageAnalysis - U

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

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

Description

Examples

Entity Diagram

entity-ssis_t.packageanalysis

Columns

Table 1. Columns of ssis_t.PackageAnalysis - U
PK Column Name Data Type NULL? ID

Category

varchar(1000)

NULL

ConnectionManager

varchar(5000)

NULL

ConnectionManagerID

varchar(100)

NULL

DelayValidationPropertyValue

varchar(10)

NULL

DerivedValue

varchar(5000)

NULL

DestinationColumn

varchar(5000)

NULL

ExecutedPackageName

varchar(8000)

NULL

ExecutePackageConnection

varchar(8000)

NULL

ExecutePackageExpression

varchar(8000)

NULL

ExpressionValue

varchar(5000)

NULL

IsDisabled

varchar(10)

NULL

IsSortedProperty

varchar(10)

NULL

LookupJoins

varchar(8000)

NULL

MultihashcolumnSortPosition

varchar(max)

NULL

ObjectName

varchar(500)

NULL

ObjectType

varchar(max)

NULL

ObjectTypeDescription

varchar(max)

NULL

ObjectValue

varchar(max)

NULL

PackageCreatorName

varchar(1000)

NULL

PackageName

varchar(max)

NULL

PackagePath

varchar(5000)

NULL

PackageProtectionLevel

varchar(100)

NULL

PackageSequenceNo

int

NULL

ParameterBindingParameterName

varchar(1000)

NULL

ParameterBindingSequence

varchar(1000)

NULL

ResultSetParameterName

varchar(1000)

NULL

RetainSameConnectionProperty

varchar(100)

NULL

RowID

int

NULL

Script

varchar(max)

NULL

SequenceNo

int

NULL

SortKeyPosition

varchar(10)

NULL

SourceColumn

varchar(5000)

NULL

TableRowID

int

NOT NULL

(1,1)

TaskPath

varchar(max)

NULL

Variable

varchar(1000)

NULL

Foreign Key Diagram

entity_1_1_fk-ssis_t.packageanalysis

References

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-ssis_t.packageanalysis

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssis_t.packageanalysis

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssis_t.packageanalysis

Column Reference Diagram

entity_1_1_colref-ssis_t.packageanalysis

Column Details

_

Category

Category

varchar(1000)

NULL

ConnectionManager

ConnectionManager

varchar(5000)

NULL

ConnectionManagerID

ConnectionManagerID

varchar(100)

NULL

DelayValidationPropertyValue

DelayValidationPropertyValue

varchar(10)

NULL

DerivedValue

DerivedValue

varchar(5000)

NULL

DestinationColumn

DestinationColumn

varchar(5000)

NULL

ExecutedPackageName

ExecutedPackageName

varchar(8000)

NULL

ExecutePackageConnection

ExecutePackageConnection

varchar(8000)

NULL

ExecutePackageExpression

ExecutePackageExpression

varchar(8000)

NULL

ExpressionValue

ExpressionValue

varchar(5000)

NULL

IsDisabled

IsDisabled

varchar(10)

NULL

IsSortedProperty

IsSortedProperty

varchar(10)

NULL

LookupJoins

LookupJoins

varchar(8000)

NULL

MultihashcolumnSortPosition

MultihashcolumnSortPosition

varchar(max)

NULL

ObjectName

ObjectName

varchar(500)

NULL

ObjectType

ObjectType

varchar(max)

NULL

ObjectTypeDescription

ObjectTypeDescription

varchar(max)

NULL

ObjectValue

ObjectValue

varchar(max)

NULL

PackageCreatorName

PackageCreatorName

varchar(1000)

NULL

PackageName

PackageName

varchar(max)

NULL

PackagePath

PackagePath

varchar(5000)

NULL

PackageProtectionLevel

PackageProtectionLevel

varchar(100)

NULL

PackageSequenceNo

PackageSequenceNo

int

NULL

ParameterBindingParameterName

ParameterBindingParameterName

varchar(1000)

NULL

ParameterBindingSequence

ParameterBindingSequence

varchar(1000)

NULL

ResultSetParameterName

ResultSetParameterName

varchar(1000)

NULL

RetainSameConnectionProperty

RetainSameConnectionProperty

varchar(100)

NULL

RowID

RowID

int

NULL

Script

Script

varchar(max)

NULL

SequenceNo

SequenceNo

int

NULL

SortKeyPosition

SortKeyPosition

varchar(10)

NULL

SourceColumn

SourceColumn

varchar(5000)

NULL

TableRowID

TableRowID

int

NOT NULL

(1,1)

TaskPath

TaskPath

varchar(max)

NULL

Variable

Variable

varchar(1000)

NULL