ssis.PackageTask_Dft_SrcDest_tgt - V

Description

Examples

Entity Diagram

Columns

Table 1. Columns of ssis.PackageTask_Dft_SrcDest_tgt - V
Column Name	Data Type	NULL?
AntoraModule	`varchar(50)`	`NOT NULL`
ControlFlowDetailsRowID	`int`	`NOT NULL`
DataFlowDetailsRowID	`int`	`NOT NULL`
DataSource	`varchar(50)`	`NULL`
DestinationColumn	`varchar(8000)`	`NULL`
DFTConnectionManager	`varchar(max)`	`NULL`
DFTRowSet	`varchar(max)`	`NULL`
DFTSQLCommand	`varchar(max)`	`NULL`
DFTTaskName	`varchar(max)`	`NULL`
DFTTasksPath	`varchar(max)`	`NULL`
DFTTaskType	`varchar(max)`	`NULL`
DFTTaskType1	`varchar(max)`	`NULL`
InputQry	`xml`	`NULL`
IsSortedProperty	`varchar(10)`	`NULL`
MultihashcolumnSortPosition	`varchar(max)`	`NULL`
OutputQry	`xml`	`NULL`
PackageName	`varchar(200)`	`NULL`
ParameterBindingParameterName	`varchar(2000)`	`NULL`
SortKeyPosition	`varchar(10)`	`NULL`
SourceColumn	`varchar(8000)`	`NULL`
TaskPath	`varchar(8000)`	`NULL`
Variable	`varchar(max)`	`NULL`

Foreign Key Diagram

References

Object Reference Diagram - 1 1

Object Reference Diagram - Referenced - 30 0

Object Reference Diagram - Referencing - 0 30

Column Reference Diagram

Column Details

_

AntoraModule

varchar(50)

NOT NULL

ControlFlowDetailsRowID

int

NOT NULL

DataFlowDetailsRowID

int

NOT NULL

DataSource

varchar(50)

NULL

DestinationColumn

varchar(8000)

NULL

DFTConnectionManager

varchar(max)

NULL

DFTRowSet

varchar(max)

NULL

DFTSQLCommand

varchar(max)

NULL

DFTTaskName

varchar(max)

NULL

DFTTasksPath

varchar(max)

NULL

DFTTaskType

varchar(max)

NULL

DFTTaskType1

varchar(max)

NULL

InputQry

xml

NULL

IsSortedProperty

varchar(10)

NULL

MultihashcolumnSortPosition

varchar(max)

NULL

OutputQry

xml

NULL

PackageName

varchar(200)

NULL

ParameterBindingParameterName

varchar(2000)

NULL

SortKeyPosition

varchar(10)

NULL

SourceColumn

varchar(8000)

NULL

TaskPath

varchar(8000)

NULL

Variable

varchar(max)

NULL